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
In mysql, what is joins? Explain
How do I switch users in mysql?
what is the difference between between and in operators in mysql?
How to use in conditions?
Is mysql case-sensitive?
In how many ways we can retrieve the data in the result set of MySQL using PHP? What is the difference between mysql_fetch_object and mysql_fetch_array ?
What are the functions used to encrypt and decrypt the data present in mysql?
How do I edit a trigger in mysql?
What are procedures in mysql? Explain
What is mysql data directory?
Why is mysql popular?
Difference between CHAR and VARCHAR?
How to display top 10 rows in mysql?
What does blob mean in mysql?
What are ddl statements in mysql?