"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 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.. > > TIA, EllioT > > > --------------------------------------------------------------------- > 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