By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
429,116 Members | 1,509 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 429,116 IT Pros & Developers. It's quick & easy.

phpmyadmin error #1064: error in SQL syntax

P: 1
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!
Jun 14 '11 #1
Share this Question
Share on Google+
1 Reply


JKing
Expert 100+
P: 1,206
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?
Jun 16 '11 #2

Post your reply

Sign in to post your reply or Sign up for a free account.