/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

0 vote122 views1 answer
Typical max-connect-errors mysql
SQL
0 vote105 views1 answer
Find the names of sailors who have reserved a red boat, and list in the order of age
SQL
3 votes111 views1 answer
Two select sql
SQL
0 vote117 views1 answer
Mysql filter based on datediff
SQL
0 vote135 views1 answer
The SELECT permission has not been granted on 'sys.sql_logins' for the 'master' database. You must be a member of the 'loginmanager' role to access this system view.
SQL
0 vote119 views1 answer
How to locate pg_hba.conf file
SQL
0 vote107 views1 answer
Pl/sql loop example
SQL
0 vote110 views9 answers
Linq to sql converter online
SQL
0 vote102 views1 answer
Partitioning in oracle-base
SQL
0 vote152 views1 answer
How to use mysql_tzinfo_to_sql on windows
SQL

Share