ALTER TABLE table_name change OLD_COLUMN_NAME NEW_COLUMN

How can we change the name of a column of a table?

Question Posted / tushar

Answer Posted / tushar

ALTER TABLE table_name change OLD_COLUMN_NAME
NEW_COLUMN_NAME VARCHAR(255) NULL;

Is This Answer Correct ?

6 Yes

0 No

Please Help Members By Posting Answers For Below Questions

Where is mysql data stored linux?

1012

What is the maximum size of table in mysql?

1028

How can you move the master database

2042

What is RMS Migrations

2395

What are the critical issues you have resolved in your company

2234

What is the difference between timestamp and datetime in mysql?

1049

What are the differences between binary and varbinary?

1049

What is ndb in mysql?

963

What is striped backup

2240

What is the data source name for mysql?

952

What is localhost in mysql?

1002

How show all tables in mysql query?

930

How do I copy an entire mysql database?

894

Is mysql same as sql?

892

How to load data files into tables with 'mysqlimport'?

996