MySQL Update Query

By: Prem Tiwari | Last Updated: | In: MySQL Tutorial

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.