I don't think quoted identifiers are supported in 3.22.x.
--jeff
- Original Message -
From: "Steve Edberg" <[EMAIL PROTECTED]>
To: "Elliot L. Tobin" <[EMAIL PROTECTED]>; <[EMAIL PROTECTED]>
Sent: Monday, May 13, 2002 3:42 PM
Subject: Re: Pro
'when' is a reserved word:
http://www.mysql.com/doc/R/e/Reserved_words.html
I don't think MySQL is using it yet, but it's probably forbidden by
the ANSI SQL standard. If you really want to use it as a column name,
I think you can quote it -
CREATE TABLE news(..., 'when' timest
"WHEN" is listed as a reserved word:
http://www.mysql.com/doc/R/e/Reserved_words.html
--jeff
- Original Message -
From: "Elliot L. Tobin" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Monday, May 13, 2002 1:22 PM
Subject: Problem with DDL
> I pulled this DDL from a MySQL server an
WHEN is a reserved word, so you need to choose another name for that field
hth
Peter
---
Excellence in internet and open source software
---
Sunmaia
www.sunmaia.net
[EMAIL PROTECTED]
tel. 0121-242-1473
-
"when" is a reserved word. If you really wanna have it as a column you have
to put it in between backticks, i.e. `when` . Unless you absolutely have to
, don't use reserved words as your column, table names for sake of
clarification.
See: http://www.mysql.com/doc/R/e/Reserved_words.html
Gurha
