One thing you can do to get around large INSERT collumn count matching is
use this syntax:
INSERT INTO user SET Host='localhost', User='username',
Password=password('very_secret'), Select_priv='Y', Insert_priv='Y',
etc.etc.etc.
You will have to identify your table first, use:
desc user
Maybe this will help.
R.
On Sat, 26 Jun 2004, LW Ellis wrote:
> Kjell,
> I tried setting up the following line (from you)
>
> INSERT INTO
> VALUES
> ('localhost','username',password('very_secret'),
> 'Y','Y',etc...);
>
> I have used anywhere from 6 to 14 'Y' (from the MySQL handbook)
> I get the following error
> Column count doesn't match value count at row 1
> Where did I go wrong.
> I have been playing around with a sample DB until now...
> Thanx in advance.
> Leon
>
>
> > Users:
> > insert into user
> >
> (host,user,password,Select_priv,Insert_priv,Update_priv,Delete_priv,Create_p
> riv,Drop_priv)
> > values
> ('localhost','us_allprivileges',password('verysecret'),'Y','Y','Y','Y','Y','
> Y');
> >
>
> _______________________________________________
> [EMAIL PROTECTED] mailing list
> http://lists.freebsd.org/mailman/listinfo/freebsd-questions
> To unsubscribe, send any mail to "[EMAIL PROTECTED]"
>
_______________________________________________
[EMAIL PROTECTED] mailing list
http://lists.freebsd.org/mailman/listinfo/freebsd-questions
To unsubscribe, send any mail to "[EMAIL PROTECTED]"
