/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

0 vote174 views1 answer
How to export table data from mysql table in sql format
SQL
0 vote175 views1 answer
Psql no such file or directory
SQL
1 vote188 views1 answer
Raise application error in oracle
SQL
0 vote199 views1 answer
Run sql script file and changes db name in this file using c#
SQL
3 votes191 views1 answer
APEX elapsed time
SQL
0 vote202 views1 answer
Command to give readonly access to a postgres sql user
SQL
0 vote172 views1 answer
Sql get month from date
SQL
32 votes183 views6 answers
Insert into values select
SQL
1 vote178 views1 answer
T-sql find object by name
SQL
2 votes178 views4 answers
How to find 2nd highest salary in mysql
SQL

Share