Home → Installation and System Configuration →

mysql

• Edit

skatkov

30 Jul, 2010 04:51 PM

I was following instructions on installing Cascade Server and I got this strange error when trying to create cascade database in mysql 5.0.45

mysql> create database cascade;
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 'cascade' at line 1
mysql>

when i change the name a little (for example cascade1), the database gets created just fine:
mysql> create database cascade1;
Query OK, 1 row affected (0.00 sec)
mysql>

My only guess is that word "cascade" has some command syntax meaning in mysql. I'm new to mysql.
anyone has any ideas or ran in to same issue?
thank you!

1. 1 Posted by Joel on 30 Jul, 2010 04:59 PM

   

   Hi,

   The term cascade is a reserved word in MySQL, please see the link below for an example of this functionality:

   http://stackoverflow.com/questions/511361/how-do-i-use-on-delete-ca...

   Since it is a reserved work, you have to wrap the word "cascade" in ` marks.

   I.e. mysql> create database `cascade` ;

   Thanks!

   • Edit

2. 2 Posted by skatkov on 30 Jul, 2010 05:14 PM

   

   Excellent! thank you Joel.
   that was my guess about reserved word, only i tried different quote marks " and ' but none of those worked.
   So that solved it.
   By the way it's good idea to update install instructions for newbies like myself :)

   • Edit

3. Support Staff 3 Posted by Tim on 30 Jul, 2010 08:33 PM

   

   Hi,

   I've updated our documentation to make sure that the database named cascade appears in tick marks.

   Thanks!

   • Edit

4. Tim closed this discussion on 30 Jul, 2010 08:33 PM.