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

6 votes199 views1 answer
Postgres get size of database
SQL
42 votes282 views6 answers
Rename table sql server
SQL
-2 votes196 views3 answers
Sqlite reset autoincrement
SQL
8 votes191 views3 answers
Postgres connection string
SQL
10 votes192 views4 answers
Sql pagination
SQL
11 votes232 views1 answer
How to get ddl for materialized view
SQL
62 votes484 views8 answers
Mysql add column
SQL
0 vote220 views1 answer
Mysql config slave
SQL
2 votes310 views1 answer
Sql ends with string
SQL
3 votes191 views1 answer
Index using in query plsql
SQL