/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

2 votes326 views1 answer
Sql count having
SQL
15 votes338 views5 answers
Show tables in oracle
SQL
3 votes340 views2 answers
Postgres download
SQL
1 vote352 views1 answer
Postgresql substring last
SQL
31 votes327 views4 answers
How to get duplicate records with multiple field in sql
SQL
6 votes276 views2 answers
Generate c# class from sql server table
SQL
0 vote364 views1 answer
Add new column in sql with foreign key
SQL
3 votes368 views1 answer
What is having
SQL
0 vote303 views1 answer
Mysql events not work
SQL
0 vote344 views1 answer
Oracle 11g forget password
SQL

Share