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)

How do I restart mysql on windows?

910

---

How do I change the max connections in mysql?

839

---

How do I disconnect mysql workbench?

1000

---

What is blob and clob?

902

---

How to get the number of rows selected or affected by a sql statement?

877

---

What is the difference between sql and mysql and oracle?

830

---

What is difference between mysqli and pdo?

879

---

What is the current mysql version?

954

---

How do I change global variables in mysql?

858

---

What are the different tables present in MySQL?

1055

---

What sql does mysql use?

880

---

can you elaborate on blob and text in mysql? : Mysql dba

849

---

How many triggers are possible in mysql?

917

---

What is a user defined variable?

852

---

How do I free up space in mysql?

860

---