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