o Change DataType of Column: Sy: Alter Table <Table Name> Modify <

How can we change the name and data type of a column of a
table?

Question Posted / ashish

Answer Posted / ashish

o Change DataType of Column:
Sy: Alter Table <Table Name> Modify <ColumnName> <DataType>;
Ex: Alter Table Test Modify EmpId varchar(5);

Is This Answer Correct ?

10 Yes

4 No

Please Help Members By Posting Answers For Below Questions

How to check if a record exists in a mysql database php?

937

What is mysql root?

999

How do I rename a procedure?

921

In mysql, what is the default storage engine?

1062

What is a scalar function?

1042

How do I start mysql in linux?

955

What is max connections in mysql?

994

What are the steps involved in query processing?

939

What sql does mysql use?

998

write a command to view the content of the table

951

What is a query in mysql?

1066

What is definer in mysql?

1009

What is difference between inner vs self vs cross?

1010

Define REGEXP?

1143

How to delete a table.

972