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)

Where is the mysql data directory?

991

---

Can mysql scale horizontally?

1034

---

how you will Create a database on the mysql server with unix shell.

1106

---

Is mysql free for commercial use?

971

---

What are the applications required to support mysql?

1001

---

How do I stop a mysql service?

1060

---

What are date and time data types in mysql?

1070

---

How show all tables in mysql query?

990

---

What's new in mysql 8?

1043

---

How many rows can be inserted in mysql at a time?

1059

---

How would you get the current date in mysql?

1159

---

How many tables we can create in mysql database?

995

---

What is the use of mysqli_query?

930

---

How many concurrent queries can mysql handle?

945

---

What is the difference between now() and current_date()?

1022

---