SQL Update Query in MS SQL Example

Learn how to update a data in SQL Table, how to write sql update query syntax in MS SQL server, in sql programming, you often need to update table record with different conditions, so in example we see how to update single row and also updating multiple row with sql where clause.

How to update record in SQL database table

SQL UPDATE query is used to update / modify the existing records in any SQL table. You can use the WHERE clause (if you want to update any specific record) with the UPDATE , if there is no Where Clause specified then all the rows would be affected.

UPDATE sqlTablename
SET column1 = value1,
    column2 = value2
WHERE [condition];

Let’s assume we have some customer data in below customer table, and we want to update one particular record

tbCustomer
--+----+----------+-----+-----------+----------+-------
| Id | Name | Code | City | Mobile |
+----+----------+-----+-----------+----------+---------
| 1 | Ajit | 0112 | Mumbai | 9819014758 |
| 2 | Ropesh | 0247 | Delhi | 7852147458 |
| 3 | Aniket | 0142 | Kolkata | 8852414758 |
|  4 | Brinda   |  0235 | Pune          |  9952504758 |
|  5 | Aman     |  0478 | Raipur        |  9652114758 |
|  6 | Kajal    |  0268 | Goa           |  9452565758 |
|  7 | Purnendu |  1403 | Bangalore     |  9652727538 |
+----+----------+-----+-----------+----------+--------

Now we write a query to update mobile number of a particular customer.
let's look at the query.

Update tbCustomer
set Mobile='8054069773'
where Code=0112

After executing the above query, if you again check the data in table, you will see one record has been updated

tbCustomer
--+----+----------+-----+-----------+----------+-----
| Id | Name     | Code |   City   |       Mobile   |
+----+----------+-----+-----------+----------+------
|  1 | Ajit     |  0112 | Mumbai        |  8054069773 |
|  2 | Ropesh   |  0247 | Delhi         |  7852014758 |
|  3 | Aniket   |  0142 | Kolkata       |  8852104758 |
|  4 | Brinda   |  0235 | Pune          |  9954254758 |
|  5 | Aman     |  0478 | Raipur        |  9652014758 |
|  6 | Kajal    |  0268 | Goa           |  9452605758 |
|  7 | Purnendu |  1403 | Bangalore     |  9652720758 |
+----+----------+-----+-----------+----------+--------

Note: if you don't specify where clause, all the data in that table will be updated, so be careful before executing any update statement in SQL

Whether SQL query will update single record or multiple records that will depend on where clause criteria, whatever records satisfy the criteria, will be updated with that sql statement.