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
Can we write procedure in mysql?
What is a trigger in mysql?
What is mysql_pconnect?
What is trigger in mysql with example?
List some mysql advantages and disadvantages?
How will show all records containing the name "sonia" and the phone number '9876543210'
What is unsigned in mysql?
What are the 'mysql' command line arguments?
Can we use mysql and mysqli together?
In mysql, what is the default storage engine?
What is different between sql and mysql?
Can mysql function return a table?
What are the three types of queries?
Can mysql store files?
How we can create index in mysql?