/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 vote282 views1 answer
Mysql find missing values
SQL
-1 vote268 views1 answer
Search all tables all columns for a specific value in mssql-server
SQL
0 vote318 views1 answer
How to create notes in mysql
SQL
0 vote314 views1 answer
What are the advantages of MySQL when compared with Oracle?
SQL
0 vote303 views1 answer
Can you write relational algebra into sql queries
SQL
0 vote271 views1 answer
Minecraft duping allowed servers
SQL
0 vote279 views2 answers
Android sqlite tutorial for beginners
SQL
0 vote247 views1 answer
Delete all rows from table sqlite
SQL
2 votes288 views2 answers
Change mysql password from command line
SQL
0 vote297 views1 answer
Ajouter une contrainte de clé étrangère sql
SQL

Share