/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

6 votes273 views4 answers
Rror: ER_NOT_SUPPORTED_AUTH_MODE: Client does not support authentication protocol requested by server; consider upgrading MySQL client
SQL
0 vote304 views1 answer
Cube oracle
SQL
6 votes266 views2 answers
WHERE value IS sql
SQL
24 votes263 views4 answers
Mssql get all table names
SQL
0 vote265 views1 answer
Casterar postgres
SQL
1 vote230 views1 answer
Postgres division by zero
SQL
0 vote298 views1 answer
Sql date time query find
SQL
0 vote272 views1 answer
Where field is null sql knex
SQL
0 vote274 views1 answer
Write a PL/SQL to print even numbers upto 100.
SQL
0 vote274 views1 answer
Get the Db column names from a SqlDataReader
SQL

Share