Date: Sat, 26 Jun 2004 01:08:23 -0600 From: "LW Ellis" <lwellis@mindspring.com> To: "Kjell Midtseter" <junkmail@sensewave.com> Cc: freebsd-questions@FreeBSD.org Subject: Re: mysql install problem Continued Message-ID: <001c01c45b4c$5fbe84e0$0200a8c0@LLAPTOP> References: <40D3FEDB.18460.6334A2@localhost>
next in thread | previous in thread | raw e-mail | index | archive | help
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');
>
Want to link to this message? Use this URL: <https://mail-archive.FreeBSD.org/cgi/mid.cgi?001c01c45b4c$5fbe84e0$0200a8c0>