Horje
sql update multiple tables Code Example
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



Sql

Related
how do you insert boolean to postgresql Code Example how do you insert boolean to postgresql Code Example
load data infile mariadb slow Code Example load data infile mariadb slow Code Example
constraint sql Code Example constraint sql Code Example
mariadb LOAD DATA INFILE Code Example mariadb LOAD DATA INFILE Code Example
sql Code Example sql Code Example

Type:
 Code Example
Category:
 Coding
Sub Category:
 Code Example
Uploaded by:
 Admin
Views:
 7



 

Horje