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'); 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 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 Link to comment https://forums.phpfreaks.com/topic/133419-solved-mysql-modify/#findComment-693925 Share on other sites More sharing options...
Recommended Posts
Archived
This topic is now archived and is closed to further replies.