Free Classified Site - Bedpage

MySQL Update Query

Prem Tiwari - - MySQL Tutorial


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.

Recommended Tutorials

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.