Answers for "mysql update where not in"

SQL
0

mysql update where not in list

UPDATE table
SET available=1
WHERE available=0   
AND id NOT IN (id1, id2, id3,...);
Posted by: Guest on November-28-2020

Code answers related to "SQL"

Browse Popular Code Answers by Language