Andy Smith wrote:
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
------------------------------------------------------------------------
_______________________________________________
Peterboro mailing list
[email protected]
https://mailman.lug.org.uk/mailman/listinfo/peterboro
Thanks Andy I will give that a try tonight.
I am also on debian sarge, not sure of the debian and mysql versions
though off the top of my head.
Thanks again. I'll report back if I can't get it going.
Stu
_______________________________________________
Peterboro mailing list
[email protected]
https://mailman.lug.org.uk/mailman/listinfo/peterboro
