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 is difference mysql and mysqli?

515

What are the differences between char and varchar?

559

How do I view a mysql database?

483

What is mysqlcommand?

479

Is mysql distributed?

497

How can an index be declared in mysql?

462

What are the 3 main types of search queries?

459

HOW TO FIND display the total number of weeks in the year of 1998 IN EMP TABLE

1818

Consider a scenario where you have to send an email to a client from the sql database. How do you think you can achieve this task?

515

How do I create a mysql username and password?

498

What is the datatype of image?

512

What is 'mysqladmin' in mysql?

526

What is mysqli_select_db?

523

What are the objects can be created using CREATE statement?

550

What is a query in mysql?

480