MySQL Update Query


mysql

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.

Leave a Reply

Your email address will not be published. Required fields are marked *

This site uses Akismet to reduce spam. Learn how your comment data is processed.