Sign in Get Started

update multiple columns in sql

A-312 
-- Oracle
UPDATE table2 t2 SET (VALUE1, VALUE2) = 
    (SELECT COL1 AS VALUE1, COL1 AS VALUE2 FROM table1 t1 WHERE t1.ID = t2.ID);
-- SQL Server
UPDATE table2 t2 SET
    t2.VALUE1 = t1.COL1,
    t2.VALUE2 = t1.COL2
FROM table1 t1
INNER JOIN t2 ON t1.ID = t2.ID;
-- MySQL
UPDATE table2 t2 INNER JOIN table1 t1 USING (ID)
SET T2.VALUE1 = t1.COL1, t2.VALUE2 = t1.COL2;
View another examples Add Own solution
Log in, to leave a comment

0
0
IllusiveBrian 18110 points 

                                    UPDATE Person.Person
 Set FirstName = 'Kenneth'
    ,LastName =  'Smith'
 WHERE BusinessEntityID = 1

0
0
4
4
A-312 69370 points 

                                    -- 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)

4 (4 Votes)
0
0
0
Awgiedawgie 440215 points 

                                    UPDATE table-name SET column-name = value, column-name = value WHERE condition = value

0
0
3.78
9
A-312 69370 points 

                                    /*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;

3.78 (9 Votes)
0
Are there any code examples left?
Find Add Code snippet
New code examples in category SQL
SHOW MORE
Create a Free Account
Unlock the power of data and AI by diving into Python, ChatGPT, SQL, Power BI, and beyond.
Sign up
Develop soft skills on BrainApps
Complete the IQ Test
Relative searches
sqlsrv query update column multiple times sqlsrv multiple updates in single sql statement sql update 2 columns with same value sql update 2 columns at once multiple field update sql sql query to update multiple columns from another table sql update statement two Tables update multiple tables in one stament sql server update multiple tables sql server sql set 2 fields in update set multiple columns with update update multiple tables in one method update multiple records in sql server two set in update sql sql alter table multiple columns update two columns in the same table sql sql update multiple statements update sql multiple update multiple table in single query update multiple table in sql update sql multiple rows updating multiple columns from the same table in sql mssql update multiple columns from select sql server update multiple columns from subquery update multiple columns in sql get one column value to another column update multiple columns in sql get one column value to another update column value for multiple rows in sql update multiple values sql server update multiple column sql query sql how to update multiple columns how to update multiple columns of a row in sql sql update set multiple columns same value updating two tables in a single query in sql how to update multiple columns in sql using where clause as updating multiple rows sql update multiple columns in sql using while loop multiple rows update using single query sql server update multiple rows in sql with different values how to use multiple set statements in 1 update sql sql update table from another table multiple columns with where clause sql update table from another table multiple columns update statement for multiple columns in sql server update multiple rows from select sql update multiple query in sql combine multiple update statements sql sql query update set multiple sql query update multiple set sql with as multiple update sql with multiple update alter table sql server alter multiple columns multiple columns in if update sql how to update single column with multiple rows in sql multiple set in update query multiple table update in sql sql update query with multiple where how to update multiple columns in sql from another table how update multiple columns in sql SQL select FOR UPDATE Multiple rows sql update multiple field sql sql update multiple columns update for multiple columns in sql sql update two columns in row update multiple columns in sql by sqlqct sql update table with multiple values update multiple columns and rows in sql update multiple rows with different values in a single sql query update multiple sql query update multiple rows sql query update table sql multiple where multiple update statements in one sql query multiple column update query in sql update multiple rows same column sql server update multiple rows same column sql server how to update selected multiple rows of single column in sql set multiple columns sql update sql update multiple tablese clause multiple row update in sql sql update multiple columns* update table using single columns in multiple table how to update multiple table in single query update multiple tables mssql update multiple columns of a table by join a query sql update the table multiple columns from another query in sql update multiple columns musql from another table update multiple columns musql sql server update multiple rows from another table sql update can it update multiple rows sql server update more than one column sql update from 2 tables update multiple sql columns at once sql query for updating multiple columns based on a variable multiple column update in sql server alter multiple table sql multiple update condition in sql sql alter add multiple columns How to update sql table with multiple values update multiple rows in sql server with different values update multiple values in sql server sql server multiple update statements update query for multiple columns from another table update multiple tables using UPDATE command sql update multiple rows with different values from another table sql set multiple values at update update 2 columns at a time in sql update multiple columns in a table update multiple columns from multiple tables in sql update multiple columns selecting from another table sql server update multiple columns into existing table update table with multiple conditions sql SQL sever update multiple coloumns multiple records update in sql using table type multiple records update in sql update for multiple rows in sql sql how to update multiple rows sql multiple update in one statement update multiple tables and columns in one sql update multiple rows by select mssql query to update multiple rows in sql query to update multiple columns can you do multiple update statement sql sql server update multiple rows with different values update multiple fields sql using set sql update multiple rows from select multiple column update in single query update statement with multiple set sql update across multiple tables how to update multiple column data in sql how to update two tables in one query update sql set multiple conditions update sql set multiple values sql alter multiple columns in one statement update specific column with multiple values sql update one column with multiple values sql sql multiple table update at same time update sql with 2 tables alter query to add multiple columns in sql update multiple row sql update sql command example multiple columns multiple update statements on a table sql query for to update multiple records at time alter table alter multiple columns set multiple properties when updating sql how to set multiple values in update sql update on 2 tables sql update multiple rows sql server sql multiple update statements update multiple columns sql with list multiple set statements in update sql sql update multi table how to update multiple tables in single query how to update multiple rows of multiple column in sql update multiple columns of a row in sql update syntax in sql to set multiple values Update Multiple column With Different Values and a Single SQL Query Update Multiple Rows With Different Values and a Single SQL Query multiple update sql server update with 2 tables sql can you do multiple things in one update query sql update two columns in one sql query update query multiple columns sql update multiple fields with same valuw how to update multiple table columns in sql alter query multiple column add in sql update multiple columns in dbms sql alter multiple column sql modify multiple columns sql edit multiple columns update multiple records with different values sql sql server update multiple columns from another table update multiple tables in single query sql update several tables update multiple records in the same column sql sql update multiple rows with UDT update multiple sql items update two tables in single query in sql server multiple updates in one query sql how to set multiple values in update query how to update multiple tables in single query in sql server sql update multiple table ms sql server update table set multiple columns select and update multiple records in a table sql update multiple records in a table sql sql query to update multiple rows sql update to multiple tables from one statement how to update data in multiple tables in single query update data from multiple tables modify multiple columns in sql update 2 tables in one query sql update data in two in sql with one query set value for multiple columns sql update multiple columns in sqlalchemy update multiple item sql server update multiple records in sql how to update multiple records in sql can you update multiple columns in sql update two tables in single query in sql update table from another table with multiple records update query in sql with multiple table value conditions update query in sql set single value in multiple where condition update query in sql set multiple values sql update multiple rows with different values call a function to update multiple columns from different tables alter table sql multiple columns sql query update two tables ms sql update multiple rows with different values sql alter multiple tables update with multiple set in sql update multiple data in table sql server alter multiple columns update multiple columns in one update sql how to update multiple records in sql for same one column update multiple columns how to update multiple records in sql for same column sql update statement multiple columns sql update statement multiple sets single update query for multiple tables how to update multiple column values in sql sql update if update multiple columns update query in sql multiple columns sql update multiple querys sql multiple set update sql server multiple set in update how to update multiple rows in sql with join update multiple fields sql how to update the multiple rows in sql how to update the multiple columns in sql can you update multiple columns at a time in sql update multi column sql sql update two columns value sql update multiple columns same value SQL UPDATE MULTIPLE ROWS DIFFERENT WHERE update in 2 tables sql update multiple attributes sql SQL UPDATE with multiple set and Where sql query to update multiple rows with different values sql statement to update multiple columns multiple update in sql update query for multiple rows update multiple columns values in case statement in sql update sql for multiple rows update sql for multiple columns sql query multiple update wuth different values update multiple query with tables update query with multiple tables how to update several rows in sql updating multiple columns in sql with multiple conditions how to update multiple field in sql sql update from another table multiple columns how to change multiple columns in sql t-sql update multiple rows update several columns query set several values for where in sql update update sql query for multiple rows alter table multiple column sql server sql update multiple where update multiple columns in sql multiple where update table set multiple columns update 2 tables in one query update multiple value sql can we update two columns in a single query in sql how to update multiple rows in sql sql alter table alter multiple column update with multiple values sql sql update multiple columns with different where clauses in one statement sql update multiple columns in one statement sql update multiple column size update several rows sql sql update 2 columns in a table from another table sql update 2 columns from another table alter datattypes of multiple columns sql alter multiple columns for a table how to update one column with multiple values in sql update multiple column datatype in sql alter multiple column sql sql server alter table modify multiple columns Update Multiple Columns with single query in SQL Server alter multiple columns sql using updating multiple column values using the select statment in sql server mssql update multiple tables update multiple records sql sql update multiple tables at once sql update on multiple tables sql update multiple columns with different conditions update multiple columns with multiple conditions in sql update multiple rows and columns sql update multiple rows and column sql set multiple update mssql 2 set on update sql sql update multiple tables sql to update multiple columns tsql update multiple columns update multiple rows with different data in sql update data columns sql multiple update a multiple column in sql update table sql multiple set sql update multiple rows from another table mssql server update multiple rows for one column update multiple rows with different values sql sql update set multi column sql server multiple table update update multiple table names sql update multiple table sql name sql update multiple fields at same time set multiple column values in a single update statement in sql sql case update multiple columns sql server alter column multiple update multiple columns sql from another column multiple update column in sql how to update more than two column in sql server update multi columns sql update statement sql server multiple columns update multiple columns sql with multiple values sql update multiple columns sql with multiple values update multiple columns sql with one subquery multiple field updates in sql how to write multiple update statements in sql update statement for multiple columns sql update one column multiple values multiple value update in sql sql update multiple columns from select update multiple columns in sql by incrementing one column value how to update multiple rows of single column in sql server update multiple rows in sql server update multiple feilds sql update multiple rows column based from another table sql update multiple rows single column two query sql update multiple rows single column sql update two columns at once do update set multiple columns update multiple rows in column sql update multiple entries sql multiple update for one column in sql alter multiple columns in sql server trigger update of multiple columns update multiple value in a row sql sql syntax update set multiple columns update multiple tables sql alter query in sql with multiple values update multiple values table sql how to combine multiple update columns in sql sql alter multiple columns sql update multiple update data types of multiple columns sql server query mssql update table multiple columns change multiple values in a column in sql add multiple columns in sql alter update multiple column sql sql update query multiple columns values sample sql update multiple table columns update multiple fields in sql table SQL update several fields with same value how to update multiple rows of single column in sql alter multiple columns in sql update multiple columns in sql query update multiple rows in a single column sql update multiple rows sql how to update multiple values in one column in sql update multiple columns in sql server with single update query update multiple rows in sql update set many variable sql server sql update two columns update more than one column sql set multiple columns in update statement sql sql update several columns how to copy columns from one table to another in sql sql copy whole column to another table sql command to update multiple columns update multiple column in sql sql set multiple sql server update table multiple set update multi values sql update query in sql for multiple columns update set sql multiple columns update query for multiple columns update many columns sql UPDATE SQL WITH MORE SET update query 2 columns update multiple columns sql query sql update multiple parameter sql updating multiple columns sql server update column from another table sql update multiple rows multiple sets in update sql sql update query multiple set statements SQL script multiple column update un champ sql multiple columns how to update two different columns in sql update command to set multiple columns sql update multiple columns from another table update multiple fields in sql set two values in update query update sql query multiple columns how to update multiple sets of data in sql update sql query to update multiple columns sql for updating multiple columns msql how to update more than one field in sqql update multiple columns in ms sql update table set column = column + 1 set two columns wiht update update query multiple columns in sql update multiple fields in the same query multiple set where in sql update statement multiple update queries in mssql server sql server update multiple where update table sql column with more than one value update query to update multiple columns update two values at once sql sql update multiple columbs c# sql multiple update SQL multiple UPDATE SQL mutiple SET how update multiple column in sql how to update multiple rows with different values in sql how to write an update statement in sql across multiple tables t sql script update column multiple tables in one statement 2 update queries sql update sql multiple values multiple update statement in sql sql set update multiple columns update multiple columns sqlite sql multiple update set sql server update many fields multiple update sql query set data multiple fields quickest way to update a column in sql for multiple conditions sql multiple update statements in one query update multiple columns with case statement in sql set multple columns same sql multiline update SQL update 2 columns sql How to update multiple columns using update statement update multiple column values in sql Updating two variables in sql set multiple values sql update table multiple columns sql multipal set sql update multi ple colum dat in sql update table set true sql upadate table set mulriple things sql update 2 columns where sql update two fields sql syntax update multiple fields update sql products update statement sql set multiple columns by different conditions update statement sql set multiple columns update 2 columns in sql update 2 column in sql update set multiple columns sql multiple field update update set multiple update multiple column name in sql update multiple columns name sql multiple set sql update multiple update set sql update table set multiple columns update sql multiple columns updating multiple statements in sql update multiple columns in sql with single where update multiple columns in sql with multiple where statements update mulitiple comlumn in query update multiple set multiple set sql how to update two columns in a database multiple set in update sql update multiple columns at the same time update table with multiple set update statement multiple columns sql query update multiple columns multiple column update in sql update query in sql with multiple set values how to write 2 update in once qurty mssql set multiple values mssql update multiple columns how to update more values in single parameter sql query update query set multiple values updating multiple attributes sql update multiple set sql update sql query to set multiple values change multiple values update query sql updating multiple values in sql update query syntax for multipple sql update query multiple columns where id to id sql update query multiple columns sql update many fields multiple update query in sql sql update multiple fields sql server update multiple fields from select sql server update set multiple columns how to update two columns in sql query how to update multiple values in sql how to set 2 columns to something in one sql statement sql sql update set multiple query update sql statement for multiple columns from a table sql query for update multiple columns how to update value in database from every device how to update 2 columns in sql change multiple attributes in sql using alter update query for more than one column in sql server multiple set in update sql how to set multiple columns in update sql update two fields sql We can update more than one column for more than one rows in a single update query update statement set multiple columns SET MUTIPLE COLUMNS EQUAL TO VIEW IN UPDATE one update multiple set shere set multiple columns in update statement in sql server update set more than one field multiple set in update\ change multiple column values in sql sql queries wuth multiple set how to update more than one column in sql updating two columns in sql update in sql multiple columns sql update 2 values multiple columns update in sql sql set multiple values does sql update multiple fields apply changes one by one update statement sql multiple columns update several columns sql mutliplt set sql SQl udate multip[le paraemters how to update two columns simultaneously in sql update with multiple set statements sql set multiple columns in sql update sql multiple set sql update double value sql update multiple columns multiple where update many column in sql c# sql update multiple columns integer sql update 2 columns update multiple values in sql sql update set multiple values update 2 columns in sql server how to set two column value in sql update multiple columns mssql updating multiple columns in sql query to update multiple columns in sql update multiple coloum in sql update query with multiple values sql query to update multiple columns in a table mult update sql using in mult update sql how to update two field in sql set multiple columns sql set multiple values in sql update update query with multiple columns mssql update more than one column in sql update multiple columns in sql server sql update multiple column sql update multiple entries updating multiple rows in tsql how to change multiple number values in a table sql how to change multiple values in a table sql update sql set multiple columns update set sql multiple values update multiple columns in single query update multiple fields sql query sql update multiple sets can we give 2 where parameter in an update query sql update individual product update query in sql with multiple values update multiple columns sql server multiple sets sql update multiple columns in sql sql server update multiple columns update two columns in sql update statement in sqlserver using multiple parameters sql update multiple set sql update list of two columns set multiple update sql update in sql for multiple values sql add 2 to a column in update statement update set multiple columns sql server update multiple columns sql set multiple value sql multiple where sql multi update sql query update multiple rows update query where condition sql update set multiple update queries in mssql update multiple sql sql update set multiple column updating multiple columns in sql server sql query to update multiple columns sql update set multiple columns how to update several columns in sql SQL how to two sets in one update how to update multiple columns in sql update sql more than one row sql update multiple values sql update multiple values in table update set multiple sql set multiple values in sql how to update two columns in sql update multiple record with different information sql? more than one value set on where update sql multiple set UPDATE sql where and sql UPDATE A FIELD WHERE CONDITION multiple update sql sql update multiple records sql Update Multiple xolumns sql update table select column names from different table sql how to update 2 values in sql server using single query sql update multi columns update 2 values SQL update two columns in sql query sql with multiple column updates updating multiple rows in sql update query multiple set values set 2 fields sql multiple set statements in sql update oracle sql update multiple columns like insert update query two columns update multiple values sql sql update syntax multiple columns sql set multiple columns same value update sql multiple fields sql update multiple columns update multiple columns at once sql update few columns sql sql change multiple values update set multiple columns sql
Made with love
This website uses cookies to make IQCode work for you. By using this site, you agree to our cookie policy

Welcome Back!

Sign up to unlock all of IQCode features:
  • Test your skills and track progress
  • Engage in comprehensive interactive courses
  • Commit to daily skill-enhancing challenges
  • Solve practical, real-world issues
  • Share your insights and learnings
Create an account
Sign in
Recover lost password
Or log in with
Not registered?
Sign up takes less than a minute

Create a Free Account

Sign up to unlock all of IQCode features:
  • Test your skills and track progress
  • Engage in comprehensive interactive courses
  • Commit to daily skill-enhancing challenges
  • Solve practical, real-world issues
  • Share your insights and learnings
Create an account
Sign up
Or sign up with
By signing up, you agree to the Terms and Conditions and Privacy Policy. You also agree to receive product-related marketing emails from IQCode, which you can unsubscribe from at any time.
Creating a new code example
Code snippet title
Source