On Wed, Jul 12, 2006 at 02:42:33PM +0100, Stuart Bird wrote:
> 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.
Works for me:
mysql> 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;
Query OK, 0 rows affected, 1 warning (0.22 sec)
What errors are you seeing exactly?
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
