/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 vote257 views1 answer
How to fetch data in between startfromdate to starenddate in sql
SQL
1 vote177 views1 answer
Set autoincrement to 0
SQL
0 vote183 views1 answer
Trigger stock phpmyadmin output message
SQL
0 vote200 views1 answer
Convert sqlalchemy.util._collections to list of string
SQL
1 vote184 views1 answer
Altering the column name in MySQL to have a default value
SQL
0 vote187 views1 answer
Mysql, how to query the table comments?
SQL
1 vote177 views1 answer
Mysql select row max date
SQL
0 vote177 views1 answer
How to move a columns location in mysql
SQL
-1 vote205 views1 answer
An error occurred while installing mysql (2.9.1), and Bundler cannot continue
SQL
19 votes176 views2 answers
Mysql add column after another
SQL

Share