Bug #1347 forbidden name ?
Submitted: 19 Sep 2003 6:12 Modified: 19 Sep 2003 6:28
Reporter: [ name withheld ] Email Updates:
Status: Not a Bug Impact on me:
None 
Category:MySQL Server: Command-line Clients Severity:S3 (Non-critical)
Version:MySQL Version 4.0.12 OS:Microsoft Windows (Microsoft windows 2000 5.00.2195)
Assigned to: CPU Architecture:Any

[19 Sep 2003 6:12] [ name withheld ]
Description:
apparently i have not the right to use the field name "force" for SQL table

How to repeat:
mysql> create table essai1 (force smallint);
ERROR 1064: You have an error in your SQL syntax.  Check the manual that corresp
onds to your MySQL server version for the right syntax to use near 'force smalli
nt)' at line 1

mysql> create table essai1 (force1 smallint);
Query OK, 0 rows affected (0.01 sec)
[19 Sep 2003 6:25] MySQL Verification Team
Yes force is a reserved word:

http://www.mysql.com/doc/en/Reserved_words.html
[19 Sep 2003 6:28] 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

FORCE is a keyword, so to use it as an identifier, you'll
need to quote it within backticks as `force`.  See:

http://www.mysql.com/doc/en/Legal_names.html