/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 vote121 views1 answer
Generate random data postgresql
SQL
0 vote122 views1 answer
Postgresql using reserved word as column name
SQL
1 vote116 views1 answer
Postgresql escape single quote
SQL
0 vote118 views1 answer
List all permissions on a table in postgres
SQL
0 vote115 views2 answers
How to update the multiple rows in sql
SQL
0 vote149 views1 answer
Sql create and grant user access to database
SQL
3 votes109 views1 answer
MySQL DELETE JOIN
SQL
0 vote122 views1 answer
Sql sum show 0 result
SQL
4 votes114 views2 answers
Raise errors.NotSupportedError( mysql.connector.errors.NotSupportedError: Authentication plugin 'caching_sha2_password' is not supported
SQL
1 vote123 views1 answer
Oracle nvl2
SQL

Share