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

Reply via email to