/SQL/MySQL update with subquery

MySQL update with subquery

MySQL update with subquery

update Users set Valid = 0
where Id in (
  select Id from (
    select Id from Users where Id < 100
  ) as t
)

0

Source: inforbiro.com

Similar codes

0 vote296 views1 answer
Sqlite version check
SQL
1 vote281 views2 answers
List tables sqlalchemy
SQL
1 vote255 views1 answer
Truncate table in postgresql and reset id
SQL
0 vote299 views2 answers
Add colum in sql
SQL
0 vote287 views1 answer
Como hacer una consulta de un registro que no esta en una tabla en mysql
SQL
0 vote270 views1 answer
Mysql wsrep ls
SQL
0 vote287 views2 answers
Mysql dump structure only
SQL
2 votes286 views1 answer
Scaffold npgsql net core
SQL
0 vote324 views1 answer
VERIFY INDEXES WITH PARTITIONS IN SQL ORACLE
SQL
5 votes273 views1 answer
How to use rank function in sql
SQL

Share