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 to delete the repeated records from a table?

1042

What is mysql good for?

963

What is tee command in mysql?

1002

What is mysqli_result?

992

How can you retrieve a portion of any column value by using a select query?

975

What are the advantages of mysql?

1042

How to include comments in sql statements?

1018

How to insert dynamic values in mysql using php?

1186

How do I insert an image into mysql workbench?

1018

What are procedures in mysql? Explain

1030

what is the difference between gui testing and database testing? : Mysql dba

1169

What are enums used for in mysql?

1052

What is a mysql server?

1037

Why are function needed?

1006

In which format data is stored in mysql database?

1057