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


Please Help Members By Posting Answers For Below Questions

How to install mysql?

512


How does php communicate with mysql?

459


How to run 'mysql' commands from a batch file?

476


How to drop an existing table in mysql?

535


How do I restart mysql on windows?

461






How can I create a database in mysql?

451


What is delimiter in mysql stored procedure?

458


What do ddl, dml, and dcl stand for?

460


How to get current MySQL version?

572


Does mysql use sql?

471


Explain the architecture models of SQL Server?

1882


Which datatype is used for email in mysql?

454


How do I restore a database in mysql workbench?

473


How do I flush privileges in mysql?

477


What is a text delimiter?

491