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

Write a program using the select statement, while loop.

474

Explain the different types of constraints?

521

Is mysql owned by oracle?

541

How do you determine the location of mysql data directory?

495

How do I flush privileges in mysql?

499

Does mysql use t sql?

578

How to show all records starting with the letters 'sonia' and the phone number '9876543210'

523

What tools available for managing mysql server?

543

write a command to view the content of the table

500

What is logs in mysql?

492

Why is mysql popular?

493

Is mariadb faster than mysql?

469

What is row?

571

How do I stop a mysql command?

487

How is mysql database stored?

537