See section 7.39 of the manual. 'when' is a reserved word in 3.23.
--
"There cannot be a crisis today. My schedule is already full."
--Henry Kissinger
> -----Original Message-----
> From: Alan Halls [mailto:[EMAIL PROTECTED]]
> Sent: Monday, January 15, 2001 15:15
> To: [EMAIL PROTECTED]
> Subject: FW: Selecting a random record
>
>
> Any idea why I get this error when I try to create this table
> on a clean
> 3.23.30 install on a BSDI box.
> This was the output from a mysqldump from version 2.22.32 on a working
> database. It will not allow me to recreate my database on the
> new version.
>
> mysql> CREATE TABLE pp_additional_features (
> -> id int(11) DEFAULT '0' NOT NULL auto_increment,
> -> profile_id varchar(11) DEFAULT '0' NOT NULL,
> -> video char(3) NOT NULL,
> -> audio char(3) NOT NULL,
> -> slide_show char(3) NOT NULL,
> -> toll_free char(3) NOT NULL,
> -> scanning char(3) NOT NULL,
> -> numpicts varchar(11) NOT NULL,
> -> type_letter char(3) NOT NULL,
> -> cards char(3) NOT NULL,
> -> when datetime DEFAULT '0000-00-00 00:00:00' NOT NULL,
> -> approved char(3) NOT NULL,
> -> KEY id (id)
> -> );
> ERROR 1064: You have an error in your SQL syntax near 'when
> datetime DEFAULT
> '0000-00-00 00:00:00' NOT NULL,
> approved char(3) NOT NU' at line 12
---------------------------------------------------------------------
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