Java Coder
How alter table in MySQL?
1 Answer(s)      2 years and 9 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

Ads

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










Ads

Advertisement