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