The UPDATE statement is used to update records in a table.
The UPDATE statement is used to update existing records in a table.
Note: Notice the WHERE clause in the UPDATE syntax. The WHERE clause specifies which
record or records that should be updated. If you omit the WHERE clause, all records will be
The "Persons" table:
Now we want to update the person "Nehwal, Jakob" in the "Persons" table.
We use the following SQL statement:
The "Persons" table will now look like this:
Be careful when updating records. If we had omitted the WHERE clause in the example above, like
The "Persons" table would have looked like this:
Your Query was successfully sent!