MySQL Tutorial

MySQL Update Query


In this tutorial, you will learn, how to update the database table’s record using the mysql update query. Use the below syntax to write the update query:

Example based on above update query syntax:

Above query will update the employee name from the old name to new name as “Ramesh Singh” based on emp_id. After that execute the below mysql query to see the updated records from employee table.

After executing the above select query, you will see the updated records.