Online Hibernate Training just in Rs. 1000

One week online training in Hibernate ORM framework. Learn Hibernate Framework and enhance your skills. Best Online Hibernate training at 90% discount. Join Now!! Offer is valid Only for limited Period!!! Online Training Big Data and Hadoop Training Java Training  
 

How alter table in MySQL?

Ads

 
 

Share on Google+Share on Google+

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

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