mysql error (dash in table name)?

Do you have a question? Post it now! No Registration Necessary.  Now with pictures!

Threaded View

How can I correct this error apart from eliminating the dash in

Couldn't execute query 'SELECT * FROM United-Kingdom ORDER BY level
DESC': 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 '-Kingdom ORDER BY level DESC' at line 1

Re: mysql error (dash in table name)?

 ( decided we needed to hear...
Quoted text here. Click to load it

Put back-ticks around the table name. Personally though, I'd remove
the dash and save the hassle of remembering the back-ticks.
(Remove REMOVE for email address)

Site Timeline