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
---------------------------------------------------------------------
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php