How can we change the name and data type of a column of a
table?
Answer Posted / abhishek
ALTER TABLE `<tablename>` CHANGE `<old column>` `<new
column>` new datatype( length )
| Is This Answer Correct ? | 5 Yes | 15 No |
Post New Answer View All Answers
What is the difference between mysql and pdo?
Is blocked because of many connection errors unblock with mysqladmin flush hosts?
Can we store pdf files in mysql?
What is ISAM?
How do I download mysql?
What is a definer?
How many rows can mysql hold?
What are the limitations of mysql?
What is trigger in mysql with example?
How to get a list of columns in an existing table?
How do I restore a mysql database?
How do I run mysql?
Explain the difference between mysql_fetch_array(), mysql_fetch_object()?
What is data directory in mysql?
How to calculate the difference between two dates?