Java Coder
How alter table in MySQL?
1 Answer(s)      a year and 8 months ago
Posted in : SQL

Hi,

I have a table and I want to alter an int field into text field. How to alter the table in MySQL?

Thanks

Advertisement
View Answers

December 14, 2013 at 4:14 PM


Hi,

You can use the following query:

alter table employees change empid empid varchar(100);

Check the tutorial Mysql Alter Column Datatype.

Check more examples of alter table statements in MySQL.

Thanks