From owner-freebsd-questions Sun Sep 3 15:17:41 2000 Delivered-To: freebsd-questions@freebsd.org Received: from pop.idx.com.au (pop.idx.com.au [203.14.30.10]) by hub.freebsd.org (Postfix) with ESMTP id 2746437B42C for ; Sun, 3 Sep 2000 15:17:38 -0700 (PDT) Received: from freebsd.freebsd.org (tntwc01-3-108.idx.com.au [203.166.3.108]) by pop.idx.com.au (8.9.3/8.9.3) with SMTP id JAA15113; Mon, 4 Sep 2000 09:17:17 +1100 From: Danny To: Allen Landsidel , freebsd-questions@FreeBSD.ORG Subject: Re: MySQL FOREIGN KEYS Date: Mon, 4 Sep 2000 08:26:53 +1100 X-Mailer: KMail [version 1.0.21] Content-Type: text/plain References: <4.3.2.7.2.20000903175309.00b12658@mail.megapathdsl.net> MIME-Version: 1.0 Message-Id: <00090408273703.00345@freebsd.freebsd.org> Content-Transfer-Encoding: 8bit Sender: owner-freebsd-questions@FreeBSD.ORG Precedence: bulk X-Loop: FreeBSD.ORG And in response to postgresql ican you install that using ports ? Is there a big learning curve between mysql and postsql? On Mon, 04 Sep 2000, Allen Landsidel wrote: > At 07:36 09/04/2000 +1100, Danny wrote: > > > >When I connect to the database and I type in DESCRIBE Assign > >It doesn't show Foreign keys in the database design > > > >Question > > > >1) Is mySQL not ANSI SQL compliant? > >2) How would I code the SQL in the above example to use Foreign keys ? > > mySQL is not ANSI SQL complient. I don't recall if it even supports > Foreign keys or not, but it's missing a lot of other things you probably > want from a real RDBMS like transactions. > > I strongly recommend you look at Postgresql if you're looking for a free > RDBMS, it's a lot more compliant and robust than mySQL. > > > > > To Unsubscribe: send mail to majordomo@FreeBSD.org > with "unsubscribe freebsd-questions" in the body of the message -- To Unsubscribe: send mail to majordomo@FreeBSD.org with "unsubscribe freebsd-questions" in the body of the message