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

Can you tell what are various ways to create an index?

855

What is pdo in php mysql?

917

What is the difference between now() and current_date()?

959

How can I see all mysql databases?

870

What is mysql common?

883

Write a query to stop mysql in unix

1027

When to use order by in delete statement?

1006

What is indexing in mysql?

936

Is mysql frontend or backend?

886

Explain triggers and stored procedures?

901

What is the use of mysqli_query?

865

Is mysql case-sensitive?

871

Is mysql a relational database?

814

Write a query to fetch duplicate records from a table using mysql?

914

How do I create a stored procedure in mysql?

876