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 the LIKE and REGEXP operators?
How to rename an existing table in mysql?
How will you export tables as an xml file in mysql?
What is flush privileges in mysql?
Why is the basic difference between left join, right join and inner join?
Describe mysql transaction properties.
What is join in mysql? What are the different types of join?
What is mysqli_num?
What is pragma exception?
How can I remotely connect to mysql database?
Who developed mysql?
How do I tune a mysql query?
Can we write pl sql mysql?
How to Change a users password from MySQL prompt. Login as root. Set the password. Update privs.
What is insert query in mysql?