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 ----------------------------------------------- > -----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 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