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

What is difference between mongodb and mysql?

911

What are enums used for in mysql?

1002

Is sql and mysql same?

923

What is the command used to create a database using php and mysql?

1146

How to update database permissions/privilages.

971

What is memory table in mysql?

940

What data structure does mysql use?

999

can you elaborate on blob and text in mysql? : Mysql dba

892

Why mysql is used with php?

970

Is mysql free download?

851

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

926

How do I change a procedure in mysql?

1007

What is mysql_query?

852

How to calculate expressions with sql statements?

1114

How can you retrieve a particular number of records from a table?

931