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 data types in mysql?

877

Can we store videos in mysql database?

887

table a has records 1,1,1,1 table b has records 1,1,1,1,1,1 what would be out if perform join for all cases

1296

How to returns the columns and column information pertaining to the designated table.

988

What is the size of mysql database?

897

What are triggers in mysql?

884

What is dump in mysql?

836

How do you name a table?

846

What is the insert?

848

Is foreign key indexed mysql?

847

How to convert character strings to numeric values?

1071

What is mysql root?

903

What are the advantages of MySQL when compared with Oracle?

897

How triggers can be used in mysql?

974

What is maximum table size in mysql?

907