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