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
How to delete the repeated records from a table?
What is mysql good for?
What is tee command in mysql?
What is mysqli_result?
How can you retrieve a portion of any column value by using a select query?
What are the advantages of mysql?
How to include comments in sql statements?
How to insert dynamic values in mysql using php?
How do I insert an image into mysql workbench?
What are procedures in mysql? Explain
what is the difference between gui testing and database testing? : Mysql dba
What are enums used for in mysql?
What is a mysql server?
Why are function needed?
In which format data is stored in mysql database?