/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 votes226 views2 answers
Safe update mode in mysql
SQL
0 vote206 views1 answer
Sql query to check if column contains alphabets
SQL
0 vote221 views1 answer
Mysql DDL
SQL
3 votes207 views1 answer
Oracle apex warning message
SQL
0 vote202 views1 answer
Zsh-syntax-highlighting zsh-autosuggestions
SQL
0 vote240 views1 answer
Sql today at midnight
SQL
-1 vote234 views1 answer
Sql show custom constraints
SQL
0 vote220 views2 answers
Search stored procedures
SQL
0 vote204 views1 answer
Mysql regex exact match
SQL
0 vote213 views1 answer
Sauvegarde complète my sql
SQL

Share