Update query in sql

This article is tagged with: Update query in sql and mysql

update column sql server

UPDATE table_name
SET column1 = value1, column2 = value2, ...
WHERE condition;

sql update query

--update query example
UPDATE table_name
SET column1 = value1, column2 = value2, ...
WHERE condition;

update query in sql

UPDATE Customers
SET ContactName='Juan'
WHERE Country='Mexico';

update query in sql

UPDATE Student SET NAME = 'PRATIK';

sql update record

UPDATE table_name
SET column1 = value1, column2 = value2...., columnN = valueN
WHERE [condition];

update a row in sql

UPDATE table_name
SET column1 = value1, column2 = value2, ...
WHERE condition;

This article is tagged with: Update query in sql and mysql