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
---
> -Original Message-
> From: Elliot L. Tobin [mailto:[EMAIL PROTECTED]]
> Sent: 13 May 2002 21:22
> To: [EMAIL PROTECTED]
> Subject: Problem with DDL
>
>
> I pulled this DDL from a MySQL server and am trying to load
rved_words.html
Gurhan
-Original Message-
From: Elliot L. Tobin [mailto:[EMAIL PROTECTED]]
Sent: Monday, May 13, 2002 4:22 PM
To: [EMAIL PROTECTED]
Subject: Problem with DDL
I pulled this DDL from a MySQL server and am trying to load it into a
MySQL server runinng 3.22.49, but I get erro
I pulled this DDL from a MySQL server and am trying to load it into a
MySQL server runinng 3.22.49, but I get errors with the DDL.
CREATE table news (
id smallint(5) unsigned DEFAULT '0' NOT NULL auto_increment,
subject varchar(80),
when timestamp(14),
body text,
who smallint(5) unsigned DEF
