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

What are the mysql database files stored in system ?

1064

How many sql ddl commands are supported by 'mysql'?

1136

What are the functions in mysql?

957

How to calculate the difference between two time values?

1000

What is back end and front end?

907

How do I free up space in mysql?

916

How to decrement dates by 1 in mysql?

1010

what is mysql optimization in brief?

2366

how to show all records starting with the letters 'sonia' and the phone number '9876543210' limit to records 1 through 5.

911

Is mysql a distributed database?

977

What is mysql_pconnect?

909

can you tell the order of sql select statement? : Mysql dba

914

What is key in mysql?

894

How do I select a table in mysql?

937

Can mysql and mariadb coexist?

1095