/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

3 votes284 views2 answers
Sql add year to date
SQL
0 vote276 views1 answer
Call object contructor and call methods of object
SQL
0 vote254 views1 answer
Caused by: java.lang.RuntimeException: Unable to obtain credentials to communicate with the Cloud SQL API
SQL
0 vote255 views1 answer
Codigo crear tablas sql server
SQL
21 votes247 views6 answers
Docker run mysql
SQL
1 vote279 views1 answer
Increase existing date in sql
SQL
0 vote278 views1 answer
Sql today at midnight
SQL
2 votes237 views1 answer
Mysql auto increment jumping
SQL
0 vote245 views1 answer
Minus equivalent in my sql
SQL
-1 vote213 views1 answer
How to create script to connect to oracle database and run query
SQL

Share