Answers for "how to update data in multiple tables in single query in mysql having foreign keys"

SQL
0

mysql update two tables at once

UPDATE t1 LEFT JOIN t2 ON t1.id = t2.f_key
   SET t1.value = t1.value + 1,
       t2.value = t2.value + 1
 WHERE t1.id = condition
Posted by: Guest on December-03-2020

Code answers related to "how to update data in multiple tables in single query in mysql having foreign keys"

Code answers related to "SQL"

Browse Popular Code Answers by Language