Updating Rows in a Table
The UPDATE
statement can be used for updating certain rows from a table.
Following is the syntax of the UPDATE
statement:
UPDATE table_name
SET column1 = value1,
column2 = value2,
...
WHERE condition;
The UPDATE
statement selects rows from the targeted table based on the given condition and updates them with the values given after the SET
keyword, for their corresponding columns.
Example: Updating Students' Data
Consider a table students
having the columns name
, age
, score
and grade
. By default the grade
is set to 'None'
for all students.
We would like to change the grade to 'A+'
for all the students with a score
greater than 90
. This can be done using the following query:
UPDATE students
SET
grade= 'A+'
WHERE
score > 90;
Demonstration:
Thanks for your feedback!
Ask AI
Ask AI
Ask anything or try one of the suggested questions to begin our chat
Awesome!
Completion rate improved to 1.72
Updating Rows in a Table
Swipe to show menu
The UPDATE
statement can be used for updating certain rows from a table.
Following is the syntax of the UPDATE
statement:
UPDATE table_name
SET column1 = value1,
column2 = value2,
...
WHERE condition;
The UPDATE
statement selects rows from the targeted table based on the given condition and updates them with the values given after the SET
keyword, for their corresponding columns.
Example: Updating Students' Data
Consider a table students
having the columns name
, age
, score
and grade
. By default the grade
is set to 'None'
for all students.
We would like to change the grade to 'A+'
for all the students with a score
greater than 90
. This can be done using the following query:
UPDATE students
SET
grade= 'A+'
WHERE
score > 90;
Demonstration:
Thanks for your feedback!