Hi All
I am trying to create a table in MySql but keep reaching a problem
which prevents the table from being created.
I have input the following, in sequence, via a mysql shell:
/CREATE TABLE ftpd (
User varchar(16) NOT NULL default '',
status enum('0','1') NOT NULL default '0',
Password varchar(64) NOT NULL default '',
Uid varchar(11) NOT NULL default '-1',
Gid varchar(11) NOT NULL default '-1',
Dir varchar(128) NOT NULL default '',
ULBandwidth smallint(5) NOT NULL default '0',
DLBandwidth smallint(5) NOT NULL default '0',
comment tinytext NOT NULL,
ipaccess varchar(15) NOT NULL default '*',
QuotaSize smallint(5) NOT NULL default '0',
QuotaFiles int(11) NOT NULL default '0',
PRIMARY KEY (User),
UNIQUE KEY User (User)
) TYPE=MyISAM;
/
/The problem is, every time I enter the last command ( ie )
TYPE=MyISAM;), mysql returns apparently random syntax errors concerning
the strings enterd in the list above it. If I then quit and check the
database via phpmyadmin, no table has been created. I have tried several
variations without success.
/
/I can't see that I have got anything wrong, however my knowledge of
mysql is basic to say the least !
/
/Can anyone see what I am getting wrong and suggest a way to put it right ?
/
/Thanks
/
/Stu
/
_______________________________________________
Peterboro mailing list
[email protected]
https://mailman.lug.org.uk/mailman/listinfo/peterboro
