MySQL Tutorial
Introduction Installation of MySQL Getting MySQL server information RDBMS Concepts Data Definition Language Data types Managing Databases Managing Tables Managing Views Inserting records in a table Updating records in a table Deleting records from a table Retrieving Records Data Control Language Variables in MySQL Procedures in MySQL Built-In functions in MySQL User Defined functions in MySQL Triggers in MySQL Cursors in MySQL Transaction control Event scheduler Tuning MySQL Server Performance Managing users Importing and Exporting data Database Testing Workbench PHPMyAdminUpdating records in MySQL
Below query will update the birth date of the customer having id as 1. Note that date must be in the yyyymmdd format or yyyy-mm-dd format.
UPDATE CUSTOMER SET BirthDate=’19860109′ WHERE CustomerId=1;
Web development and Automation testing
solutions delivered!!