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 https://forums.phpfreaks.com/topic/133419-solved-mysql-modify/ Share on other sites More sharing options...
Jabop Posted November 19, 2008 Share Posted November 19, 2008 MySQL Forum Quote Link to comment https://forums.phpfreaks.com/topic/133419-solved-mysql-modify/#findComment-693917 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 https://forums.phpfreaks.com/topic/133419-solved-mysql-modify/#findComment-693925 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.