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: Problem with DDL > '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' timestamp, ....) > > - but it's probably best to pick another name that's not in the reserved list. > > -steve > > > At 4:22 PM -0400 5/13/02, Elliot L. Tobin wrote: > >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 DEFAULT '0' NOT NULL, > > PRIMARY KEY (id) > >); > > > >ERROR 1064 at line 3: You have an error in your SQL syntax near 'when > >timestamp(14), > > body text, > > who smallint(5) unsigned DEFAULT '0' NOT NULL' at line 4 > > > > > >-- > > > >Any help is appreciated.. Please email me directly.. > > > > > -- > +------------------------------------------------------------------------+ > | Steve Edberg [EMAIL PROTECTED] | > | University of California, Davis (530)754-9127 | > | Programming/Database/SysAdmin http://pgfsun.ucdavis.edu/ | > +------------------------------------------------------------------------+ > | "If only life would imitate toys." | > | - Ted Raimi, March 2002 | > | - http://www.whoosh.org/issue67/friends67a.html#raimi | > +------------------------------------------------------------------------+ > > --------------------------------------------------------------------- > 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 > --------------------------------------------------------------------- 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
