phpmyadmin error #1064: error in SQL syntax

Collapse
X
 
  • Time
  • Show
Clear All
new posts
  • Aron Standley
    New Member
    • Jun 2011
    • 1

    phpmyadmin error #1064: error in SQL syntax

    When I enter:
    CREATE DATABASE `cl_db`
    DEFAULT CHARACTER SET utf8
    COLLATE utf8_general_ci ;

    phpmyadmin returns:
    #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 ''cl_db' DEFAULT CHARACTER SET utf8 COLLATE utf8 general ci' at line 1

    What can I do to solve this, and keep building a database?

    Thanks for your help!
  • JKing
    Recognized Expert Top Contributor
    • Jun 2007
    • 1206

    #2
    I copy and pasted your statement into phpmyadmin and it ran without error.

    I am using phpmyadmin 3.3.9

    What version are you using? Are you still receiving this error?

    Comment

    Working...