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

What is row level locking?

928

How to show table structure mysql?

1012

What is RMS Migrations

2396

Why is mysql used?

943

How set mysql root password?

922

What is difference between statement and preparedstatement?

1004

What are date and time data types in mysql?

1026

What is the insert?

897

Why we use mysqli instead of mysql?

1091

how to search second maximum(second highest) salary value(integer)from table employee (field salary)in the manner so that mysql gets less load?

886

How do I delete a row in mysql?

973

How do I rename a mysql database?

959

What is user in mysql?

892

table a has records 1,1,1,1 table b has records 1,1,1,1,1,1 what would be out if perform join for all cases

1366

How can we get total number of records by query in mysql?

909