This SQL statement is used to update/modify the existing data for particular column in a table.
Syntax to UPDATE data in a Table is as follows −
UPDATE Table_Name
SET column1 = value1,column2 = value2, ...
WHERE condition
Demo Table : The Employee table having the following records −
Example :
The following query will update the “Salary”for a Employee whose ID number is 3 in the table.
UPDATE EMPLOYEE SET Salary = 35000 WHERE ID = 3
Result will be as follows:
If you want to update Multiple field Values like “Salary” and “Department whose ID number is 1.
UPDATE EMPLOYEE SET Salary = 15000, Department='Agriculture' WHERE ID = 1
If you want to sell your readymade software to the genuine clients or businessman, list your software with details and demo links.
Clients will find it using our advanced search filter and will contact you directly.
No any charge for the product lsiting.