Andy Smith wrote:
> Have you tried creating the table repeatedly with more and more
> columns until you narrow down the line that is causing problems?
>
> CREATE TABLE ftpd (
> User varchar(16) NOT NULL default ''
> ) TYPE=MyISAM;
>
Also note that what you are entering are single commands spread across
multiple lines, not multiple commands. The command above could be
entered on one line if you chose:
CREATE TABLE ftpd (User varchar(16) NOT NULL default '') TYPE=MyISAM;
Is there a reason why you're not using phpMyAdmin to do this, since you
have that installed? If you run the same query through phpMyAdmin what
does that say? (That ought to confirm that the syntax suits your version
of MySQL.) Something that may catch you out is if some of the field
names you're using are now reserved words, for example. I tried your SQL
here too without problems.
I assume you have a database selected in which to run the command?
Obviously (?) you can't create a table outside a database. I also assume
you have the necessary rights to do this. Your error messages don't
sound right for these being the problem.
If you put your SQL into a file (eg sql.txt), you can run it direct from
the bash prompt:
$mysql mydatabasename -u myuser -p <sql.txt
--
Mark Rogers
More Solutions Ltd :: 0845 45 89 555
_______________________________________________
Peterboro mailing list
[email protected]
https://mailman.lug.org.uk/mailman/listinfo/peterboro
