Search posts

SQL UPDATE command

SQL UPDATE command is used to update existing rows in the database.
The command structure is the following:UPDATE <tableName> SET <columnName>=<newValue> WHERE <condition>;
If we don’t put WHERE condition, then it will update all rows, so we should be very carefully to put the WHERE condition.