Question

What is the use of UPDATE command in SQL?

Answer 1

The 'UPDATE' command in SQL is used to modify existing records in a database table. It allows you to change the values of one or more columns for one or more rows in a table based on specific criteria defined by a 'WHERE' clause. If the 'WHERE' clause is omitted, all rows in the table will be updated with the new value, which should be done with caution.