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

how can you test for null values in a database? : Mysql dba

918

How do I backup mysql database on linux?

914

Where the database is stored in mysql?

941

What are date and time data types?

966

Explain the difference between delete and truncate.

964

What is the maximum no of columns a table can have?

896

Does mysql support sequence?

919

What are the common mysql functions?

925

Write a query to select all teams that won either 1, 3, 5 or 7 games.

1331

What is mysql cursor?

875

What is offset limit?

938

Do you need a license for mysql?

926

What is full form of xampp?

1147

How do I start mysql client?

947

What is row?

1069