Your database is stuffed up. Try using a different one. The Query worked on my database.
You think you can still help me with that MySql syntax error?