[SOLVED] mysql error while creating database

ramecare · 07-28-2011, 08:37 AM

Dear all,

While creating a new database iam facing the below problem,i searched in google to solve but i was not able to solve,can any one help me on this.

mysql> create database auto-download-gta;
ERROR 1064 (42000): 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 '-download-gta' at line 1

Thanks,

acid_kewpie · 07-28-2011, 08:46 AM

it's becuase you have dashes in the databse name. Ideally, don't use them, but you can quote the name using backticks apparently. Better to change the name.

TB0ne · 07-28-2011, 08:47 AM

Quote:

Originally Posted by ramecare

Dear all,
While creating a new database iam facing the below problem,i searched in google to solve but i was not able to solve,can any one help me on this.

mysql> create database auto-download-gta;
ERROR 1064 (42000): 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 '-download-gta' at line 1

Must not have looked too hard..putting "linux mysql database name dash" in pulls up 356,000 hits that explain this. The error is very clear, and well-documented. You've got a dash "-" in your database name. Either name your database something else, or put the database name in double-quotes.

If you look any of this up, you'll see LOTS of reasons for not doing this. Mysqldump had (has??) a known issue with databases with dashes in their names. Writing scripts/code for such databases also becomes problematic.

ramecare · 07-28-2011, 08:56 AM

I have given database name with in double-quotes but iam facing the same problem again

mysql> create database "auto-download-gta";
ERROR 1064 (42000): 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 '"auto-download-gta"' at line 1

Thanks,

TB0ne · 07-28-2011, 08:58 AM

Quote:

Originally Posted by ramecare

I have given database name with in double-quotes but iam facing the same problem again

mysql> create database "auto-download-gta";
ERROR 1064 (42000): 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 '"auto-download-gta"' at line 1

Ok...did you read the posts above? Dashes in a DB is *NOT* a good thing. And I'm not at my machine, so I couldn't test the double-quotes, but acid_kewpie posted about backticks. Did you read that and try it?

Once again...dashes in your DB name is not a good idea and will cause problems.

acid_kewpie · 07-28-2011, 08:59 AM

as I already said, use backticks.

For every search result about putting dashes in database names, there is another about someone using quote marks instead of backticks and complaining that it's still not working.

ramecare · 07-28-2011, 09:22 AM

I created the database using backticks,its working Thank u all

mysql> create database `auto-download-gta`;
Query OK, 1 row affected (0.02 sec)

Thanks

acid_kewpie · 07-28-2011, 09:25 AM

final hint... use a better database name.

TB0ne · 07-28-2011, 11:05 AM

Quote:

Originally Posted by acid_kewpie

final hint... use a better database name.

...and now we're looking forward to the follow-up thread, about how mysqldumps aren't working, and how programs are failing on connect.