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 install mysql?
How does php communicate with mysql?
How to run 'mysql' commands from a batch file?
How to drop an existing table in mysql?
How do I restart mysql on windows?
How can I create a database in mysql?
What is delimiter in mysql stored procedure?
What do ddl, dml, and dcl stand for?
How to get current MySQL version?
Does mysql use sql?
Explain the architecture models of SQL Server?
Which datatype is used for email in mysql?
How do I restore a database in mysql workbench?
How do I flush privileges in mysql?
What is a text delimiter?