At 15:58 +0100 3/17/03, Peter O wrote:
> When creating a table with a column named force an error is
>shown and the
>table is not created.
>When trying to do this :
>CREATE TABLE testcase (
> force int default NULL
>I get this :
>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
>'force int default NULL,
>) TYPE=MyISAM' at line 2
>Is this related to the FORCE INDEX feature ?
Yeah, the addition of this feature would have the effect of making
FORCE a reserved wordl. You can write it using backticks: `force`