Answers for "mysql update where in select"

update select mysql

UPDATE tableA a
INNER JOIN tableB b ON a.name_a = b.name_b
SET validation_check = if(start_dts > end_dts, 'VALID', '')
-- where clause can go here

Posted by: Guest on September-01-2021

Code answers related to "mysql update where in select"