Which SQL statement is used to update data in a database?
The UPDATE statement updates data values in a database. UPDATE can update one or more records in a table. Use the WHERE clause to UPDATE only specific records in a table.
UPDATE table_name SET column1 = value1, column2 = value2, ...WHERE condition;
The following SQL statement updates the first Slightbook (SlightbookID = 1) with a contact person and a course,
UPDATE Customers SET ContactName = 'Kudumula', Course= 'HTML5' WHERE CustomerID = 1;
Which SQL statement is used to extract data from a database?
What does SQL stand for?