Home All courses
Online TrainingContact UsAbout Us
Over lay
Table of Contents

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 PHPMyAdmin

Updating 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!!

Logo
Courses
  • Automation Testing
About
  • About Me
Social Media
Copyright 2024 @ www.softpost.org