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:
>Description:
>	When creating a table with a column named force an error is 
>shown and the
>table is not created.
>How-To-Repeat:
>
>When trying to do this :
>
>CREATE TABLE testcase (
>   force int default NULL
>) TYPE=MyISAM;
>
>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
http://www.kitebird.com/
sql, query
Thread
column named force not allowedPeter O17 Mar
  • Re: column named force not allowedPaul DuBois18 Mar