Answers for "mysql update with other column value of same table"

mysql update field from one table to another

UPDATE MY_TABLE AS t1
INNER JOIN MY_OTHER_TABLE AS t2 ON t1.COLID = t2.COLID
SET t1.COL1 = t2.COL1, t1.COL2 = t2.COL2
WHERE t1.COL3 = 'OK';

Posted by: Guest on August-18-2021

mysql update from select on same table

UPDATE users SET status = 1
WHERE id = (
  SELECT id FROM (
    SELECT id FROM users WHERE id = 10
  ) u
)

Posted by: Guest on October-06-2021

Code answers related to "mysql update with other column value of same table"