Latest Tutorials| Questions and Answers|Ask Questions?|Site Map



Home Answers Viewqa SQL How alter table in MySQL?

Have Programming Question? Ask it here!
 
 
 


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



Related Tutorials/Questions & Answers:
Advertisements
 

 

 

DMCA.com