/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

8 votes324 views2 answers
Oracle auto increment primary key
SQL
28 votes314 views4 answers
Show tables mysql
SQL
0 vote305 views1 answer
Sql if else in select
SQL
0 vote277 views0 answer
SQL
0 vote289 views1 answer
How to install Firebird
SQL
0 vote296 views1 answer
Select other columns with distinct
SQL
0 vote289 views1 answer
Ms sql unique
SQL
0 vote312 views1 answer
Add unique constraint sql server multiple columns
SQL
1 vote323 views1 answer
Tsql get beginning of year
SQL
3 votes313 views1 answer
How to uninstall microsoft sql server
SQL

Share