UPDATE Statement in SQL – DML Statements



Now in this SQL Post we will learn Data Manipulation Language (DML) UPDATE Statement.

UPDATE Statement in SQL – DML Statements


The UPDATE Statement – The UPDATE Statement is used to modify the records of existing table.

If we want to modify the rows data in a table we need to use UPDATE query in SQL.

The SQL UPDATE Statement Syntax :

UPDATE table_name SET  col1=val1, col2=val2, col3=val3 WHERE Condition

table_name – is the name of table  which has to be updated.
col1, col2 – is the anme of columns which records has to be updated.
val1, val2 – is the values of new records which has be updated in to table.

SQL UPDATE Statement Example :

The SQL Student Table :

ID Name City Email Mobile
1 MEERA Surat meera@meeraacademy.com 1020304050
2 Vaidehi Mumbai Vaidehi@yahoo.com 1122334455

Example – Update the email address in table Student whose id=2, the UPDATE query is :

UPDATE Student SET email=”ram@meeraacademy.com” WHERE ID=2;

The Student Table After Updated.

ID Name City Email Mobile
1 MEERA Surat meera@meeraacademy.com 1020304050
2 Vaidehi Mumbai ram@meeraacademy.com 1122334455

If we write above UPDATE Statement like below :

UPDATE Student SET City=”Pune”, Mobile=1111111111;

The Student Table After Updated.

ID Name City Email Mobile
1 MEERA Pune meera@meeraacademy.com 1111111111
2 Vaidehi Pune ram@meeraacademy.com 1111111111

Note : In UPDATE Statement, If we do not use WHERE Condition, then all records of columns to be updated in a table.

 

(Visited 52 times, 1 visits today)

Leave a Reply

Your email address will not be published. Required fields are marked *

Captcha *