blogspot visit counter

Wednesday, 28 August 2013

How to Change a Column Name in MySQL

How to Change a Column Name in MySQL
Introduction : -
In this article i am explain how i can change the column name of MySQL database table

Description :-

This is very to change the table column name in mysql database.
I have a info_tab (this is table name). And  id , user_id, Fisrt_Name, LastName

table as shown below

alter table info_tab change First_Name2 First_name varchar(30)

Here info_tab is table name 
First_Name2  is  old column name  which you want to change
Fist_Name Is new Column name  of the table

No comments:

Post a Comment

Related Posts Plugin for WordPress, Blogger...