To Change DataType of Column: Sy: Alter Table <Table Name> Modify &l

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 DataType of Column:
Sy: Alter Table <Table Name> Modify <ColumnName> <DataType>;
Ex: Alter Table Test Modify EmpId varchar(5);

Is This Answer Correct ?

63 Yes

12 No

Please Help Members By Posting Answers For Below Questions

How do I get a list of table names in mysql?

926

How to concatenate two character strings?

1035

What is the datatype of image in mysql?

919

What is database clustering in mysql?

1036

Why MySQL is used?

1037

How do I select a database in mysql workbench?

1017

What is regex in mysql?

1089

What is the latest version of mysql?

989

Who developed mysql?

1019

How do I download mysql on my laptop?

888

Where is the mysql data directory?

944

Is mysql a free database?

942

What is mysql server?

1089

How do I edit a table in mysql workbench?

852

Write a query to stop mysql in unix

1055