/SQL/How to update the multiple rows in sql

How to update the multiple rows in sql

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

How to update the multiple rows in sql

update with in condition

Similar codes

5 votes246 views1 answer
Oracle columns in all_tables
SQL
2 votes249 views1 answer
Query to find table size in oracle 12c
SQL
1 vote257 views1 answer
Select not matching data with join table
SQL
0 vote266 views1 answer
Sql query to find duplicate email address
SQL
6 votes305 views3 answers
Check if string contains substring sql
SQL
61 votes407 views6 answers
Mysql add column
SQL
0 vote273 views1 answer
Postgresql replace html tags from string
SQL
3 votes240 views2 answers
Oracle sql drop sequence
SQL
13 votes268 views3 answers
Insert mysql ifile nto database
SQL
4 votes260 views2 answers
Convert utc to est sql
SQL