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 many columns is too many mysql?

905

What is the use of mysqli_num_rows?

927

What does mysqli_fetch_assoc do?

909

What are the common mysql functions?

942

What is offset limit?

958

What causes mysql too many connections?

958

what is database black box testing? : Mysql dba

1119

How to create a table index in mysql?

968

Where is the mysql config file?

982

What is the use of i-am-a-dummy flag in mysql?

1011

What is the difference between truncate and delete?

1189

Can I install mysql on mac?

975

How do I edit a table in mysql?

895

How do I fix a crashed mysql database?

955

What is mysql aggregate functions? Explain

1088