UPDATE table_name
SET column1 = value1, column2 = value2, ...
WHERE condition;
/*Example EMPLOYEE table */
+----+--------+---------+
| id | name | email |
+----+--------+---------+
| 1 | name-1 | email-1 |
| 2 | name-2 | email-2 |
| 3 | name-3 | email-3 |
| 4 | name-4 | email-4 |
| 5 | name-1 | email-5 |
| 6 | name-2 | email-6 |
+----+--------+---------+
UPDATE EMPLOYEE SET name = 'updated name' WHERE id = 4;
/* Table data after updation*/
+----+--------------+---------+
| id | name | email |
+----+--------------+---------+
| 1 | name-1 | email-1 |
| 2 | name-2 | email-2 |
| 3 | name-3 | email-3 |
| 4 | updated name | email-4 |
| 5 | name-1 | email-5 |
| 6 | name-2 | email-6 |
+----+--------------+---------+
2014-2017 © Techburps. ALL Rights Reserved. Disclaimer Contact Us