On Wed, Jul 12, 2006 at 03:40:53PM +0100, Stuart Bird wrote: > Andy Smith wrote: > >Works for me: > > > Oh dear ! That probably means I have a bigger issue to sort out, I > thought it was just my syntax !!!
Have you tried creating the table repeatedly with more and more
columns until you narrow down the line that is causing problems?
e.g.
CREATE TABLE ftpd (
User varchar(16) NOT NULL default ''
) TYPE=MyISAM;
DROP TABLE ftpd;
CREATE TABLE ftpd (
User varchar(16) NOT NULL default '',
status enum('0','1') NOT NULL default '0'
) TYPE=MyISAM;
DROP TABLE ftpd;
CREATE TABLE ftpd (
User varchar(16) NOT NULL default '',
status enum('0','1') NOT NULL default '0',
Password varchar(64) NOT NULL default ''
) TYPE=MyISAM;
..etc
I can't see anything tricky but perhaps you are running a different
(older/newer) version of MySQL whose syntax is different? I'm
running 4.1.11-Debian_4sarge4-log.
Cheers,
Andy
--
http://strugglers.net/wiki/Xen_hosting -- A Xen VPS hosting hobby
Encrypted mail welcome - keyid 0x604DE5DB
signature.asc
Description: Digital signature
_______________________________________________ Peterboro mailing list [email protected] https://mailman.lug.org.uk/mailman/listinfo/peterboro
