how to rename an existing column (field)of Table using Alter Table Query(MySQL Beginners Tutorial)

how to rename an existing column(field) of Table using Alter Table Query(MySQL Beginners Tutorial)

MySQL Database Tutorial for Beginners

Learning Basic Concepts of MySQL.

This Video is very helpful for those who are beginners in MySQL.
This video will clear your basic concept of MySQL.

In this video of 4:21 Minutes ,you will learn in very simplest and easiest way how to RENAME Existing Column or Field of Table using CHANGE keyword along with ALTER TABLE command
in MySQL Database.

[mycaribeat]

What if I want to rename the Header like this: Alter table Mytable change Date_of_Birth "Date Of Birth" varchar (32). I Get an error with "Date Of Birth"

[diniizzati]

how can i change the data at the column date of birth?
for example:
actual data=>12/01/1998
i want to change to => 12/11/1998