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


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:

Ask a doubt
Davneet Singh's photo - Co-founder, Teachoo

Made by

Davneet Singh

Davneet Singh has done his B.Tech from Indian Institute of Technology, Kanpur. He has been teaching from the past 14 years. He provides courses for Maths, Science, Social Science, Physics, Chemistry, Computer Science at Teachoo.