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 the LIKE and REGEXP operators?

975

How to rename an existing table in mysql?

964

How will you export tables as an xml file in mysql?

832

What is flush privileges in mysql?

937

Why is the basic difference between left join, right join and inner join?

965

Describe mysql transaction properties.

958

What is join in mysql? What are the different types of join?

888

What is mysqli_num?

876

What is pragma exception?

906

How can I remotely connect to mysql database?

857

Who developed mysql?

939

How do I tune a mysql query?

825

Can we write pl sql mysql?

889

How to Change a users password from MySQL prompt. Login as root. Set the password. Update privs.

1024

What is insert query in mysql?

842