Bug #4081 can not create database named "case"
Submitted: 9 Jun 2004 18:59 Modified: 9 Jun 2004 21:11
Reporter: Stacie Email Updates:
Status: Not a Bug Impact on me:
None 
Category:MySQL Administrator Severity:S3 (Non-critical)
Version:4.0.14 OS:sunos
Assigned to: CPU Architecture:Any

[9 Jun 2004 18:59] Stacie 
Description:
The error message:

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

How to repeat:
mysql> create database case;
[9 Jun 2004 21:11] Paul DuBois 
Thank you for taking the time to write to us, but this is not
a bug. Please double-check the documentation available at
http://www.mysql.com/documentation/ and the instructions on
how to report a bug at http://bugs.mysql.com/how-to-report.php

Additional info:

"case" is a keyword. To use it as an identifier, you should quote it:

CREATE DATABASE `case`;

See:
http://dev.mysql.com/doc/mysql/en/Legal_names.html