SQL Multiple choices


Total available count: 51
Subject - Databases
Subsubject - SQL

Which SQL statement is used to update data in a database?


 

 

 

 



B


Solution:-

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 Syntax:-

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

UPDATE Table:-
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;

 




Next 2 multiple choice(s)

1

Which SQL statement is used to extract data from a database?

2

What does SQL stand for?

Comments