/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 vote103 views1 answer
Narural join
SQL
0 vote102 views1 answer
Fast sql column count
SQL
1 vote100 views1 answer
Oracle convert run duration to number
SQL
0 vote111 views1 answer
New rails app with mysql
SQL
0 vote129 views1 answer
Php insert null mysql
SQL
1 vote118 views1 answer
T-sql disable system versioning
SQL
28 votes65 views6 answers
Distinct sql
SQL
0 vote99 views1 answer
Datagrip exec
SQL
0 vote99 views1 answer
Sql contains numeric characters
SQL
0 vote98 views1 answer
If null don't update
SQL

Share