ALTER TABLE table_name change OLD_COLUMN_NAME NEW_COLUMN

How can we change the name of a column of a table?

Question Posted / vipul dalwala

Answer Posted / vipul dalwala

ALTER TABLE table_name change OLD_COLUMN_NAME
NEW_COLUMN_NAME VARCHCHAR(100) NULL;

Is This Answer Correct ?

18 Yes

3 No

Please Help Members By Posting Answers For Below Questions

How do I view tables in mysql workbench?

444

Where is mysql data stored?

474

What, if a table has one column defined as TIMESTAMP?

554

How to dump a table from a database.

530

What ascii 31?

514

Does mysql use sql?

490

Explain timestamp?

582

What is the function of mysqldump?

568

Which is faster mongodb or mysql?

447

Do you need a license for mysql?

504

How can I see mysql database?

476

Restore database (or database table) from backup.

552

What is the maximum number of columns per table?

483

How to set the time zone for MySQL to particular country time?

2720

How would you get the current date in mysql?

646