Which SQL statement is used to modify existing records in a table?

SQL Fundamentals Medium

SQL Fundamentals — Medium

Which SQL statement is used to modify existing records in a table?

Key points

  • UPDATE is used to modify existing records in a table.
  • MODIFY, ALTER, and CHANGE are not used for updating records in SQL.
  • UPDATE statement requires a WHERE clause to specify which records to modify.

Ready to go further?

Related questions