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

How many concurrent queries can mysql handle?

895

What is processlist in mysql?

1002

What is clob in mysql

942

How do I start and stop mysql server?

985

What is pdo :: fetch_assoc?

904

What is mysqli_free_result?

903

How is oracle different from mysql?

1024

How do I optimize a selected query in mysql?

930

What is pdo in php mysql?

946

What is different between sql and mysql?

1018

How many columns is too many mysql?

906

What is max connection in mysql?

931

What is table level locking in mysql?

919

What is localhost in mysql?

1006

What is view in mysql?

972