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 do I run mysql?

1005

What are the features of mysql?

988

Can mysql and mariadb coexist?

1087

Why mongodb is faster than mysql?

878

Why use stored procedures in mysql?

981

Explain csv tables.

1007

What is the data type for image?

1063

How do you say mysql?

897

Is mysql a dbms?

883

What are the mysql database files stored in system ?

1060

What is mysqli_free_result?

902

How to load data files into tables with 'mysqlimport'?

995

How to dump a table to a file with 'mysqldump'?

1025

What is mysql slow query?

948

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

986