Date: Sat, 26 Jun 2004 06:10:30 -0700 (MST) From: Technical Director <technical@server1.ultratrends.com> To: LW Ellis <lwellis@mindspring.com> Cc: freebsd-questions@freebsd.org Subject: Re: mysql install problem Continued Message-ID: <20040626060434.P92486@server1.ultratrends.com> In-Reply-To: <001c01c45b4c$5fbe84e0$0200a8c0@LLAPTOP> References: <40D3FEDB.18460.6334A2@localhost> <001c01c45b4c$5fbe84e0$0200a8c0@LLAPTOP>
next in thread | previous in thread | raw e-mail | index | archive | help
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');
> >
>
> _______________________________________________
> freebsd-questions@freebsd.org mailing list
> http://lists.freebsd.org/mailman/listinfo/freebsd-questions
> To unsubscribe, send any mail to "freebsd-questions-unsubscribe@freebsd.org"
>
Want to link to this message? Use this URL: <https://mail-archive.FreeBSD.org/cgi/mid.cgi?20040626060434.P92486>