From owner-freebsd-questions@FreeBSD.ORG  Fri Feb 11 10:47:47 2005
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 ACD0A16A4CE
	for <freebsd-questions@freebsd.org>;
	Fri, 11 Feb 2005 10:47:47 +0000 (GMT)
Received: from lorna.circlesquared.com
	(host217-45-219-85.in-addr.btopenworld.com [217.45.219.85])
	by mx1.FreeBSD.org (Postfix) with ESMTP id 3DEB943D31
	for <freebsd-questions@freebsd.org>;
	Fri, 11 Feb 2005 10:47:46 +0000 (GMT)
	(envelope-from peter@circlesquared.com)
Received: from localhost.circlesquared.com (localhost.circlesquared.com
	[127.0.0.1])j1BAlwpO072519;	Fri, 11 Feb 2005 10:47:59 GMT
	(envelope-from peter@circlesquared.com)
From: Peter Risdon <peter@circlesquared.com>
To: cinnur@comcast.net
In-Reply-To: <420BF178.9010107@comcast.net>
References: <420BF178.9010107@comcast.net>
Content-Type: text/plain
Date: Fri, 11 Feb 2005 10:47:58 +0000
Message-Id: <1108118878.23699.43.camel@lorna.circlesquared.com>
Mime-Version: 1.0
X-Mailer: Evolution 2.0.3 FreeBSD GNOME Team Port 
Content-Transfer-Encoding: 7bit
cc: "freebsd-questions@freebsd.org" <freebsd-questions@freebsd.org>
Subject: Re: SQL Questions
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: Fri, 11 Feb 2005 10:47:47 -0000

On Thu, 2005-02-10 at 18:42 -0500, Sean wrote:
> I would like to install SQL here for my own use, not for any real life 
> currently, round now for learning.
> 
> Right now plan to install MySQL.
> Looking through the ports there is numerous version and some say for 
> server, some say for client.
> 
> Looking for some tips as to what version of SQL and tools to install?
> Also wondering if anyone can point me towards documentation in my 
> learning efforts?

Hi,

I suggest you install the latest production version of mysql:

/usr/ports/databases/mysql41-server

which will install the client too. The command line client is an
excellent working environment but there are also several graphical
interfaces available. Try:

/usr/ports/databases/phpmyadmin

for a widely used web interface.

Mysql documentation can be found at:

http://dev.mysql.com/doc/mysql/en/index.html

and there are a lot of excellent books.

If you're thinking of trying web database programming and are
considering using php as the language, install php5 and mysqli
(mysqli[mproved]):

/usr/ports/lang/php5
and

/usr/ports/lang/php5-extensions
ticking the box for mysqli, or the extension port:

/usr/ports/databases/php5-mysqli

This is because php5 and mysqli can access some of the newer features in
mysql 4.1

php documentation can be accessed at:

http://www.php.net/manual/en/

HTH

Peter.