Sql update multiple tables

Update table sql multiple set

-- CANT do multiple sets but can do case
UPDATE table
SET ID = CASE WHEN ID = 2555 THEN 111111259 
              WHEN ID = 2724 THEN 111111261
              WHEN ID = 2021 THEN 111111263
              WHEN ID = 2017 THEN 111111264
         END
WHERE ID IN (2555,2724,2021,2017)

Source: stackoverflow.com

Sql update multiple tables

/*You can't update multiple tables in one statement,
however, you can use a transaction to make sure that
two UPDATE statements are treated atomically.
You can also batch them to avoid a round trip.*/


BEGIN TRANSACTION;

UPDATE Table1
  SET Table1.LastName = 'DR. XXXXXX' 
FROM Table1 T1, Table2 T2
WHERE T1.id = T2.id
and T1.id = '011008';

UPDATE Table2
SET Table2.WAprrs = 'start,stop'
FROM Table1 T1, Table2 T2
WHERE T1.id = T2.id
and T1.id = '011008';

COMMIT;

Source: stackoverflow.com

Similar codes

-1 vote177 views1 answer
Module operator in oracle sql
SQL
1 vote192 views1 answer
Postgres set sequence value to max id
SQL
0 vote191 views1 answer
Kill slow queries mysql
SQL
15 votes176 views4 answers
Pl sql
SQL
1 vote175 views1 answer
Sql server read uncommitted
SQL
1 vote162 views1 answer
Mysql select utc time in eastern time
SQL
0 vote205 views1 answer
Mysql update column default value CURRENT_TIMESTAMP error
SQL
13 votes214 views3 answers
Mysqldump structure only
SQL
1 vote187 views2 answers
Sql for date greater than
SQL
0 vote196 views1 answer
5.Query to raise salary of all employees with 300 in EMP table and display name and salary as new sal from EMP table employee name, job, and salary from EMP table.
SQL