/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 vote130 views2 answers
Pl sql case
SQL
6 votes177 views3 answers
[2021-10-05T13:43:48.961Z] error Error: ER_NOT_SUPPORTED_AUTH_MODE: Client does not support authentication protocol requested by server; consider upgrading MySQL client
SQL
0 vote130 views1 answer
Https://www.jitendrazaa.com/blog/sql/sqlserver/export-documents-saved-as-blob-binary-from-sql-server/
SQL
1 vote157 views1 answer
Mysql previous year
SQL
4 votes153 views2 answers
Oracle unlock account
SQL
0 vote159 views10 answers
John the ripper mysql
SQL
1 vote145 views1 answer
Oracle sequence last_number
SQL
0 vote134 views1 answer
Not equal to blank in mysql
SQL
1 vote126 views1 answer
Expression number 1 of select list is not in group by clause
SQL
0 vote132 views1 answer
Ubuntu stop mysql from starting on boot
SQL

Share