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_fetch_array() and ysql_fetch_object() ?

1019

Does mysql use sql?

880

How to start mysql server?

1049

How can you see all indexes defined for a table?

1112

What is mysqli_free_result?

902

What is mysql cursor?

892

How do I restore a database in mysql workbench?

1000

What is a deterministic function?

1065

What are triggers in mysql?

923

How to convert dates to character strings?

1070

Why mysql is used with php?

970

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

907

How MySQL Optimizes DISTINCT?

1104

What is meant by sharding?

920

What is a query in mysql?

993