mysql Update Record

We need to update the record, and we need to use the UPDATE statement.

Update Statement

UPDATE user

SET name='Mina', age=12

WHERE user_id=36;

DESCRIPTION

Make sure that you have the WHERE Clause when you use the UPDATE statement. Without the WHERE Clause, you will tell MySQL to UPDATE all the records.