mysql

skatkov's Avatar

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

    Joel's Avatar

    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!

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

    skatkov's Avatar

    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 :)

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

    Tim's Avatar

    Hi,

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

    Thanks!

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

Comments are currently closed for this discussion. You can start a new one.

Keyboard shortcuts

Generic

? Show this help
ESC Blurs the current field

Comment Form

r Focus the comment reply box
^ + ↩ Submit the comment

You can use Command ⌘ instead of Control ^ on Mac