/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

5 votes356 views1 answer
Sql integer to serial
SQL
4 votes329 views2 answers
Oracle sql group by date year
SQL
0 vote395 views1 answer
Why do we need data structure in sql
SQL
11 votes371 views1 answer
Oracle export view ddl
SQL
0 vote336 views1 answer
Mysql subdate
SQL
0 vote336 views1 answer
Oracle step procedure
SQL
0 vote356 views1 answer
Oracle last connexion
SQL
0 vote319 views1 answer
How to update random rows in sql
SQL
0 vote328 views1 answer
What is default mysql database password in linux
SQL
3 votes343 views3 answers
Create a view postgres
SQL

Share