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

What is the latest version of mysql?

1035

How to list or view all databases from the mysql server.

977

Which is better sqlite or mysql?

1117

How do I flush privileges in mysql?

1063

What is difference between mysql and mysqli?

983

How do I enable mysqli extension?

1068

Is mysql a database?

994

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

984

How do you connect MySQL database with PHP?

1038

How to show certain selected rows with the value "pcds".

982

How to use count function in mysql?

970

How can you calculate the sum of any column of a table?

1083

What is datadir?

942

What are date and time data types?

1042

How to Join tables on common columns.

1249