Answer Posted / guru

You can change the column data type using this query:

Alter table table_name modify column_name datatype(length)

For example:
Alter table user modify name char(30)
You can change column name using this query:

Alter table table_name change old_column_name
new_column_name datatype(length)

For example:
Alter table user change user user_name char(30)

If you want to change column name and data type in single
query, then you use this query:

Alter table table_name change old_column_name
new_column_name new_datatype(10)

For example:
Alter table user change name user_name char(30)

For more details visit,

http://www.phponwebsites.com/2013/12/mysql-change-column-name.html
(for change column name)

http://www.phponwebsites.com/2013/12/mysql-change-column-datatype.html(for
change column datatype)

Is mysql case-sensitive?

886

---

What can I do with mysql?

915

---

Are stored procedures precompiled?

981

---

Where is the mysql config file?

979

---

What is mysql sleep process?

1027

---

Explain the different types of constraints?

944

---

What is mysql root?

947

---

How to display nth highest salary from a table in a mysql query?

989

---

What are the critical issues you have resolved in your company

2232

---

Is mysql a good database?

943

---

List the different types of normalization?

943

---

Explain Access Control Lists.

986

---

How do I create a schema in mysql?

870

---

How do I copy a table in mysql?

938

---

What is a tinyint in mysql?

907

---