rofl90 Posted June 12, 2008 Share Posted June 12, 2008 ALTER TABLE `bugs` ADD `network` ENUM( myspace, facebook, hi5, friendster, homepage, bebo ) NOT NULL , ADD `debugInfo` TEXT NOT NULL MySQL said: Documentation #1064 - You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'myspace, facebook, hi5, friendster, homepage, bebo) NOT NULL, ADD `debugInfo` TE' at line 1 Very cryptic Link to comment https://forums.phpfreaks.com/topic/109953-mysql-error/ Share on other sites More sharing options...
wildteen88 Posted June 12, 2008 Share Posted June 12, 2008 You need wrap quotes around the words defined in ENUM. ALTER TABLE `bugs` ADD `network` ENUM( 'myspace', 'facebook', 'hi5', 'friendster', 'homepage', 'bebo' ) NOT NULL , ADD `debugInfo` TEXT NOT NULL Link to comment https://forums.phpfreaks.com/topic/109953-mysql-error/#findComment-564307 Share on other sites More sharing options...
Recommended Posts
Archived
This topic is now archived and is closed to further replies.