ALTER TABLE table_name change OLD_COLUMN_NAME NEW_COLUMN

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

Question Posted / vipul dalwala

Answer Posted / vipul dalwala

ALTER TABLE table_name change OLD_COLUMN_NAME
NEW_COLUMN_NAME VARCHCHAR(100) NULL;

Is This Answer Correct ?

18 Yes

3 No

Please Help Members By Posting Answers For Below Questions

Is mysql open source?

1024

What are Heap tables?

1646

Define REGEXP?

1149

How to returns the columns and column information pertaining to the designated table.

1077

using primary can we relate two table, with out foreign key?

2766

What is the difference between float and double?

1191

What is acid in mysql?

909

What are the advantages of mysql?

1042

Why use mysql procedures?

1031

How MySQL Optimizes DISTINCT?

1169

What command is used to delete the data from the table without deleting the table structure?

1043

Can I use mysql for free?

948

How can you change the password of a mysql user?

1017

What are features of mysql?

942

How would you get the current date in mysql?

1162