To Change Name of Column: Sy: Alter Table <Table Name> Change <Ol

How can we change the name and data type of a column of a
table?

Question Posted / m. ravindar

Answer Posted / m. ravindar

To Change Name of Column:
Sy: Alter Table <Table Name> Change <Old ColumnName> <New
ColumnName>;
Ex: Alter Table Test Change EmpId EID varchar(5);

Is This Answer Correct ?

17 Yes

19 No

Please Help Members By Posting Answers For Below Questions

How can we encrypt and decrypt a data presented in a table using mysql?

1063

Write a query to find duplicate rows in table?

906

What is the difference between a database and a table?

1009

How set mysql root password?

917

How do I run mysql on a mac?

968

What is max_used_connections in mysql?

949

What is trigger in mysql?

926

How do I view tables in mysql workbench?

920

Is pdo more secure than mysqli?

883

How do I find users in mysql?

1104

What is use of mysql?

928

Where is mysql used?

996

Can you tell the difference between $message and $$message?

971

How do you restart mysql?

909

How do I run mysql from command line?

1041