MasterACE14 Posted September 23, 2007 Share Posted September 23, 2007 Evening folks, I want to know, how do you change the data type of a column in MySQL, without stuffing up the database. Regards ACE Quote Link to comment Share on other sites More sharing options...
wildteen88 Posted September 23, 2007 Share Posted September 23, 2007 Use the ALTER TABLE syntax. Eg: ALTER TABLE tbl_name CHANGE col_name new_col_name DATATYPE_HERE Quote Link to comment Share on other sites More sharing options...
MasterACE14 Posted September 24, 2007 Author Share Posted September 24, 2007 ok, thank you Quote Link to comment Share on other sites More sharing options...
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.