UPDATE Statement in SQL – DML Statements

In previous SQL post we had discussed about Data Definition Language  Statements such as  CREATE Command and ALTER Command and USE Command and DROP DATABASE Command and SQL SELECT Statement and SQL INSERT Statement.

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.

 

Leave a Reply

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

8 + 1 =


You may use these HTML tags and attributes: <a href="" title=""> <abbr title=""> <acronym title=""> <b> <blockquote cite=""> <cite> <code class="" title="" data-url=""> <del datetime=""> <em> <i> <q cite=""> <strike> <strong> <pre class="" title="" data-url=""> <span class="" title="" data-url="">