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 is the use of mysql_fetch_array () function in php?

1007

What is a left join mysql?

949

How to write after insert event update trigger on the same table in mysql?

1006

How do I run mysql without installing?

1025

How do I start mysql in ubuntu?

1093

How to convert character strings to dates?

1148

How do I install the latest mysql on ubuntu?

1041

What is username in mysql?

950

What is session variable in mysql?

1026

What is mysql command line?

1124

What language does mysql use?

957

What is max connection in mysql?

989

What is delimiter $$?

1024

Can a table have multiple primary keys?

953

explain GROUPBY & HAVING clause with examples.

2334