Step: Update record

Update record

To update existing records we can use
UPDATE <TABLE> set <column>=<value>, <column2>=<value2> where <condition> expression where you can define new values and condition.

For example, this is how you could update a value in a table customers.

UPDATE customers
SET name='Chris'
WHERE email='bob@example.com'

Try to set customer name to Chris. After it's done, you can try to select again to see that the anem is updated.