UPDATE command

[pintukennady31]

Hi’
i want to know quire for update command in SQl database.

[WolfShade]

Insufficient data. Could you please elaborate? Table name, column names, etc.

The basic syntax is

UPDATE tableName
SET colA = valueA, colB = valueB
WHERE colC = valueC

HTH,

[kumarrahul01212]

UPDATE table_name
SET column1 = value1, column2 = value2…, columnN = valueN
WHERE [condition];

Table Name is Customer here
±—±---------±----±----------±---------+
| ID | NAME | AGE | ADDRESS | SALARY |
±—±---------±----±----------±---------+
| 1 | Ram | 30 | Ahmedabad | 12000.00 |
| 2 | Shyam | 21 | Delhi | 11500.00 |
| 3 | Mahesh | 28 | Kota | 7000.00 |

±—±---------±----±----------±---------+
Here above I have illustrate with an example, you can update as per your query.

SQL> UPDATE CUSTOMERS
SET SALARY = ‘10000’
WHERE ID = 3
Hop you will get some

[vembutech]

update tablename set columnname = value,… where columnname OPERATOR value and|or column OPERATOR value;