troubleshooting Question

enum

Avatar of chefkeifer
chefkeiferFlag for United States of America asked on
DatabasesPHPMySQL Server
10 Comments1 Solution4223 ViewsLast Modified:
I am trying to set up and database to use the type ENUM and have '0,'1' and it keeps getting me an error when i try to save...any thoughs to why

Error

There seems to be an error in your SQL query. The MySQL server error output below, if there is any, may also help you in diagnosing the problem

ERROR: Unclosed quote @ 88
STR: '
SQL: ALTER TABLE `pages` CHANGE `showing` `showing` ENUM(\'\'0\',\'1\'\') NOT NULL DEFAULT '1'


SQL query:

ALTER TABLE `pages` CHANGE `showing` `showing` ENUM(\'\'0\',\'1\'\') NOT NULL DEFAULT '1'

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 '\'\'0\',\'1\'\') NOT NULL DEFAULT '1'' at line 1
ASKER CERTIFIED SOLUTION
Join our community to see this answer!
Unlock 1 Answer and 10 Comments.
Start Free Trial
Learn from the best

Network and collaborate with thousands of CTOs, CISOs, and IT Pros rooting for you and your success.

Andrew Hancock - VMware vExpert
See if this solution works for you by signing up for a 7 day free trial.
Unlock 1 Answer and 10 Comments.
Try for 7 days

”The time we save is the biggest benefit of E-E to our team. What could take multiple guys 2 hours or more each to find is accessed in around 15 minutes on Experts Exchange.

-Mike Kapnisakis, Warner Bros