SQL – UPDATE

SQL Update Query

SQL – UPDATE Statement is used to update or change the records in table which are existing in the table.

SQL Update Query with Syntax

UPDATE TableName
SET columnName1 = newValue1,
SET columnName2 = newValue2,
SET columnName3 = newValue3
WHERE columnName = someColumnValue;

Suppose We have Following Data :

tableFull

Update Example :

Example

UPDATE USERS SET Name = ‘David Camron’ , City=”NEW LONDON” WHERE Email= ‘david@yahoo.com’;

The Above Query Will Update the row where email is ‘david@yahoo.com’ the update data will be as :

SQL UPDATE Query


Advertisements

Add Comment

📖 Read More