List:General Discussion« Previous MessageNext Message »
From:Paul DuBois Date:March 18 2003 2:52am
Subject:Re: column named force not allowed
View as plain text  
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`

Paul DuBois
sql, query
column named force not allowedPeter O17 Mar
  • Re: column named force not allowedPaul DuBois18 Mar