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
