Sql update query

Sql update from select

UPDATE YourTable 
SET Col1 = OtherTable.Col1, 
    Col2 = OtherTable.Col2 
FROM (
    SELECT ID, Col1, Col2 
    FROM other_table) AS OtherTable
WHERE 
    OtherTable.ID = YourTable.ID

Source: stackoverflow.com

Sql update record

SQL> UPDATE CUSTOMERS
SET ADDRESS = 'Pune'
WHERE ID = 6;

Source: tutorialspoint.com

Update Query in SQL Server

  Update salesTransaction
  Set Unit_Price=45.41,Item_Number='Milk-1'
  Where trx_id=1249

Source: naycode.com

Sql update \

UPDATE `table_name`
	SET `status` = 'offline' 
		WHERE `id` = 2386;

Update Query in SQL Server

 
  UPDATE table1
  SET column2 = 'Your Text', column3 = 45000
  WHERE column1=5

Source: naycode.com

Sql update query

srouboa

Similar codes

4 votes209 views1 answer
Check database name postgresql
SQL
2 votes206 views1 answer
Oracle sql day of month from date
SQL
1 vote236 views3 answers
How to reset id column in sql server
SQL
1 vote223 views1 answer
Postgres convert date to string
SQL
0 vote231 views1 answer
Creating a simple notify in postgresql
SQL
2 votes165 views1 answer
Oracle current date without time
SQL
8 votes227 views1 answer
Check mysql version phpmyadmin
SQL
17 votes201 views2 answers
How to assign date field for table in mysql
SQL
10 votes269 views4 answers
Join multiple tables in sql
SQL
1 vote244 views1 answer
Mariadb get column names from table
SQL