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)

What is mysql connection limit?

527

---

Write a query to find duplicate rows in table?

494

---

How do I stop a mysql service?

519

---

Can mysql store files?

506

---

How to get current MySQL version?

598

---

---

What is tee command in mysql?

496

---

What is row level locking?

511

---

Why do we use pragma autonomous transaction?

499

---

How do I view a mysql database?

487

---

What is a storage engine? What are the differences between innodb and myisam engines?

520

---

How do I clear a mysql database?

524

---

what is cte? : Mysql dba

525

---

Does mysql case matter?

501

---

How do I set user privileges in mysql?

488

---

can you tell the order of sql select statement? : Mysql dba

494

---