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 longblob in mysql?

1023

How do I restore a mysql database dump file in linux?

1035

What is bigint in mysql?

976

what is the difference between gui testing and database testing? : Mysql dba

1169

How can I see connections in mysql?

982

Why do we use group by and order by function in mysql?

967

What is the phantom problem?

1047

How do I start mysql client?

1009

Which is faster mysql or mongodb?

990

Write a command with which mysql table can be repaired

990

How do I check mysql version?

1126

How do I find users in mysql?

1181

Explain about reporting services of MYSQL?

1131

What are the difference between and myisam and innodb?

1088

How do you login to MySql using Unix shell?

1239