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)

Consider you have the following three tables which have to be linked together.

853

---

What is max connections in mysql?

876

---

Is mysql free for commercial use?

849

---

What is the use of procedure in mysql?

883

---

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

1012

---

Write a command with which mysql table can be repaired

886

---

How does mysql clustering work?

849

---

Is mysql free for enterprise?

849

---

Can I use mariadb instead of mysql?

865

---

What is normalization and list the different types of normalization?

907

---

How show all tables in mysql query?

863

---

Is mysql a free database?

891

---

How can we get total number of records by query in mysql?

854

---

How to write after insert event update trigger on the same table in mysql?

908

---

Where is mysql password stored?

873

---