ALTER TABLE table_name change OLD_COLUMN_NAME NEW_COLUMN

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

Question Posted / tushar

Answer Posted / tushar

ALTER TABLE table_name change OLD_COLUMN_NAME
NEW_COLUMN_NAME VARCHAR(255) NULL;

Is This Answer Correct ?

6 Yes

0 No

Please Help Members By Posting Answers For Below Questions

Is mysql case-sensitive?

835

Is oracle mysql free?

821

How can we get the number of rows affected by query?

988

What is the difference between sql and mysql and oracle?

824

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

839

What is the use of pdo?

900

Is mysql and sql are same?

985

change column name and make a unique column so we get no dupes.

911

What is a tinyint in mysql?

856

What is row level locking?

869

How can I insert images into a Mysql database?

998

What does the file with the extension: frm, myd, and myi contain?

872

How to convert character strings to numeric values?

1059

What is the difference between is null & is not null?

938

Is blocked because of many connection errors mysql?

790