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 see the create table statement of an existing table?

1050

Is pdo more secure than mysqli?

882

How to determine the location of the data directory?

962

How many columns can a table have?

921

Write a command to list all databases in mysql?

1041

How can I create a database in mysql?

866

can you tell what are the different set operations available in mysql? : Mysql dba

892

Why mysql is open source?

920

How do I change mysql password?

1017

What language does mysql use?

906

What is the current root password of mysql?

918

What is database engine in mysql?

937

What is truncate in mysql?

953

How do I run mysql?

1010

Which statement is used in a select query for partial matching?

1189