MYSQL update query

An update query is used to update records in the table.

For this query command, we will use the given table as an example.

Update records change first_name to Amit which has id 1

UPDATE users SET first_name="Amit" WHERE id=1;

Update multiple fields

UPDATE users SET first_name="Ramesh", last_name="Kumar" WHERE id=2;