SQL UPDATE - Learn2Done

The UPDATE statement is used to modify/update the existing record in table.

Syntax:

UPDATE table_name
SET column1 = value, ....
WHERE condition;

DEMO DATABASE:

Data

Example: To update the marks and phone number of Arun in table students.

UPDATE students
SET Total_Marks = 84, Phone_Number = 12345
WHERE Name = 'Arun';

The updated record of Arun is as follows:

Data