antoshka — Fri, 23 Jan 2004 05:56:58 +0000

this will work.

CREATE TABLE apphist(
appindex int unsigned NOT NULL auto_increment PRIMARY KEY,
approver varchar(15) NOT NULL,
member varchar(15) NOT NULL,
item tinyint(1) NOT NULL,
reason tinytext,
ok tinyint(1) NOT NULL,
`when` datetime default '0000-00-00 00:00:00' NOT NULL,
KEY approver (approver),
KEY member (member),
KEY item (item),
KEY ok (ok),
KEY `when` (`when`)
) TYPE=MyISAM;

m3rajk — Thu, 01 Jan 2004 01:54:29 +0000

the books i have have mentions of reseved words scattered around. it's likely i missed it while looking for them, but i like that page MUCH better. already bookmarked and filed it for the future =o)

i didn't think of the possibility that i might havemissed one since they're scattered. that's why i came here first. i thought itwas something inthe declaration that i was overlooking and was too minor for me to see since i'm "too close to the code"

thanx again for the reserved word page =o)

Mark Hensler — Wed, 31 Dec 2003 15:18:35 +0000

http://www.mysql.com/doc/en/Reserved_words.html

"WHEN" is on the list. Though, I don't remember ever using it.

Busy — Wed, 31 Dec 2003 07:45:13 +0000

I think when and ok are reserved words (could be wrong)

try adding is_ok and did_when or something and see if the errors go away