/SQL/Mysql update two tables at once

Mysql update two tables at once

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

0

Mysql update one table from another table multiple columns

 update  tabe2 set subject_id = (SELECT GROUP_CONCAT(sub_id SEPARATOR ', ') as sub_id FROM tabe1)

0

Source: stackoverflow.com

Similar codes

-1 vote345 views1 answer
How to use update trigger in sql
SQL
3 votes326 views1 answer
System.debug apex
SQL
0 vote335 views1 answer
Check mysql password with docker container magento 2
SQL
0 vote376 views1 answer
Execute sql stored procedure in powershell
SQL
0 vote362 views1 answer
Mysql not defined
SQL
6 votes437 views4 answers
Mysql get random row
SQL
0 vote354 views1 answer
Cursor.execute (sql, value) ValueError: operation parameter must be str
SQL
1 vote416 views1 answer
T-sql disable system versioning
SQL
24 votes366 views4 answers
Mysql datetime
SQL
0 vote364 views1 answer
Const pool = mysql.createpool()
SQL

Share