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 the difference between mysql and pdo?

910

Is blocked because of many connection errors unblock with mysqladmin flush hosts?

876

Can we store pdf files in mysql?

936

What is ISAM?

1060

How do I download mysql?

842

What is a definer?

832

How many rows can mysql hold?

844

What are the limitations of mysql?

989

What is trigger in mysql with example?

876

How to get a list of columns in an existing table?

842

How do I restore a mysql database?

1026

How do I run mysql?

940

Explain the difference between mysql_fetch_array(), mysql_fetch_object()?

886

What is data directory in mysql?

922

How to calculate the difference between two dates?

998