alter table <table_name> change <old_column_name> <new_column_name> <column_defination>
Example: -
alter table registration change name fullname varchar(200)
Rename a table column in MySQL
SQL,
,
2010-04-25 21:59:29
About the author
Hi, I am Sachin Puri, I am a Programmer. Programming is my work and it is the thing i like to do most in my free time.
You can catch Sachin Puri at Google+
Hi, I am Sachin Puri, I am a Programmer. Programming is my work and it is the thing i like to do most in my free time.