ALTER TABLE `<tablename>` CHANGE `<old column>` `<new colum

How can we change the name and data type of a column of a
table?

Question Posted / abhishek

Answer Posted / abhishek

ALTER TABLE `<tablename>` CHANGE `<old column>` `<new
column>` new datatype( length )

Is This Answer Correct ?

5 Yes

15 No

Please Help Members By Posting Answers For Below Questions

What is cast in mysql?

954

What is the hostname for mysql database?

1065

How do I fix a crashed mysql database?

1008

How does mysql clustering work?

969

How to rename an existing column in a table?

1109

What is view in mysql?

1019

What is the purpose of mysql database?

968

What are the common mysql functions?

1001

What does a TIMESTAMP do on UPDATE CURRENT_TIMESTAMP data type?

985

How to return query output in html format?

980

Is mongodb faster than mysql?

995

How do I show users in mysql?

1118

How do you say mysql?

956

How do I select a database in mysql?

1121

What are the similarities between a function and a procedure?

958