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



Home Answers Viewqa SQL How alter table in MySQL?
Login         

View Questions and Answers by Category

Advertisements


 
Have Programming Question? Ask it here!
 
 
 


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

 

 

DMCA.com