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

What are the types of database engines available in mysql?

953

Write a query to create a database and a table?

851

What is append query?

864

Can mysql and mariadb coexist?

1020

What, if a table has one column defined as TIMESTAMP?

935

How to see the create table statement of an existing table?

986

What is relational database in mysql?

879

How do I delete a row in mysql?

891

Is mysqli deprecated?

892

What is orm in mysql?

852

How To see all the tables from a database of mysql server.

1006

What is deterministic in mysql?

927

What you can use regular expression for in mysql? Support your answer with an example?

843

What is the difference between char and varchar?

1095

How do I select a database in mysql workbench?

944