mySQL syntax error: please check

[rednaxel]

i'm trying to create a table in mySQL. could someone please tell me why mySQL keeps telling me that this syntax is invalid:

CREATE TABLE bids (
auction varchar(13),
bidder varchar(13),
bid double(16,4),
when timestamp(14),
quantity int(11) DEFAULT '0'
);

thanks

[[deleted]]

Could it be that you have quotes around the zero after the "default"?

[geert]

chad nantais wrote:

i'm trying to create a table in mySQL. could someone please tell me why mySQL keeps telling me that this syntax is invalid:

CREATE TABLE bids (
auction varchar(13),
bidder varchar(13),
bid double(16,4),
when timestamp(14),
quantity int(11) DEFAULT '0'
);

thanks

I think the use of fieldname 'when' is not valid. It is a reserved keyword like
'table', 'select'.

Hopefully this will solve the problem.

[[deleted]]

"where" is not listed as a reserverd word in the mysql manual.

[Anon]

Check mysql reference I think that you need to use where instead of when..

Di

[rednaxel]

The problem was with that field name 'when'. I should have known it was a reserved keyword because my IDE was highlighting it as such. Thanks for the help. Problem solved!