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 download a mysql community server?

835

What is current version of mysql?

906

What are programming functions?

885

Is mysql a programming language?

833

What is MySQL?

935

What ascii 31?

897

How would you enter characters as hex numbers?

877

How can I insert images into a Mysql database?

998

Is there a free version of mysql?

877

Write a command to view mysql database table structure?

919

How can you count the total number of records of any table?

875

What is blob and clob?

893

How do I update a variable in mysql?

884

Can we store pdf files in mysql?

916

What are the non-standard sql commands supported by 'mysql'?

922