From owner-freebsd-questions@FreeBSD.ORG  Sat Jun 26 12:17:50 2004
Return-Path: <owner-freebsd-questions@FreeBSD.ORG>
Delivered-To: freebsd-questions@freebsd.org
Received: from mx1.FreeBSD.org (mx1.freebsd.org [216.136.204.125])
	by hub.freebsd.org (Postfix) with ESMTP id 28D9C16A4CE
	for <freebsd-questions@freebsd.org>;
	Sat, 26 Jun 2004 12:17:50 +0000 (GMT)
Received: from server1.ultratrends.com (server1.ultratrends.com
	[205.206.59.239])
	by mx1.FreeBSD.org (Postfix) with ESMTP id BF25343D41
	for <freebsd-questions@freebsd.org>;
	Sat, 26 Jun 2004 12:17:49 +0000 (GMT)
	(envelope-from trodat@ultratrends.com)
Received: from server1.ultratrends.com (localhost [127.0.0.1])
	i5QDAU9m092504;	Sat, 26 Jun 2004 06:10:30 -0700 (MST)
Received: from localhost (trodat@localhost)i5QDAUh1092501;
	Sat, 26 Jun 2004 06:10:30 -0700 (MST)
X-Authentication-Warning: server1.ultratrends.com: trodat owned process doing
	-bs
Date: Sat, 26 Jun 2004 06:10:30 -0700 (MST)
From: Technical Director <technical@server1.ultratrends.com>
To: LW Ellis <lwellis@mindspring.com>
In-Reply-To: <001c01c45b4c$5fbe84e0$0200a8c0@LLAPTOP>
Message-ID: <20040626060434.P92486@server1.ultratrends.com>
References: <40D3FEDB.18460.6334A2@localhost>
	<001c01c45b4c$5fbe84e0$0200a8c0@LLAPTOP>
MIME-Version: 1.0
Content-Type: TEXT/PLAIN; charset=US-ASCII
cc: freebsd-questions@freebsd.org
Subject: Re: mysql install problem Continued
X-BeenThere: freebsd-questions@freebsd.org
X-Mailman-Version: 2.1.1
Precedence: list
List-Id: User questions <freebsd-questions.freebsd.org>
List-Unsubscribe: <http://lists.freebsd.org/mailman/listinfo/freebsd-questions>,
	<mailto:freebsd-questions-request@freebsd.org?subject=unsubscribe>
List-Archive: <http://lists.freebsd.org/pipermail/freebsd-questions>
List-Post: <mailto:freebsd-questions@freebsd.org>
List-Help: <mailto:freebsd-questions-request@freebsd.org?subject=help>
List-Subscribe: <http://lists.freebsd.org/mailman/listinfo/freebsd-questions>,
	<mailto:freebsd-questions-request@freebsd.org?subject=subscribe>
X-List-Received-Date: Sat, 26 Jun 2004 12:17:50 -0000


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"
>