This question asked in CBSE SQP-2020

Which command is used to modify the records of the table?

 

Answer:

The UPDATE command is used to modify the records of a table.

Syntax: UPDATE table_name

      SET column1 = value1 , column2 = value2 , ...

      WHERE condition ;

 

Example:

Question 2 very short  - image 1..jpg

 

Question 3 Very short- image 2.jpg

Remove Ads
Teachoo · Class 12 Explore Class 12

Transcript

This question asked in CBSE SQP-2020 Which command is used to modify the records of the table? Answer: The UPDATE command is used to modify the records of a table. Syntax: UPDATE table_name SET column1 = value1, column2 = value2, ... WHERE condition; Example:

Davneet Singh's photo - Co-founder, Teachoo

Made by

Davneet Singh

Davneet Singh is an IIT Kanpur graduate and has been teaching for 16+ years. At Teachoo, he breaks down Maths, Science and Computer Science into simple steps so students understand concepts deeply and score with confidence.

Many students prefer Teachoo Black for a smooth, ad-free learning experience.