ballhogjoni Posted November 19, 2008 Share Posted November 19, 2008 how do you change the enum column in a table? Would this be right? ALTER TABLE Hotels_media MODIFY column('1','2','3'); Quote Link to comment Share on other sites More sharing options...
Jabop Posted November 19, 2008 Share Posted November 19, 2008 MySQL Forum Quote Link to comment Share on other sites More sharing options...
Mchl Posted November 19, 2008 Share Posted November 19, 2008 ALTER TABLE `Hotels_media` MODIFY COLUMN `column` ENUM('1','2','3') I believe... Better check it. I use MySQL GUI tools for things like this 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.