From owner-freebsd-questions Sun Sep 3 14:52:20 2000 Delivered-To: freebsd-questions@freebsd.org Received: from ns1.venon.com (ns1.venon.com [64.7.7.83]) by hub.freebsd.org (Postfix) with ESMTP id 98EA837B42C for ; Sun, 3 Sep 2000 14:52:17 -0700 (PDT) Received: from megalomaniac.biosys.net (megalomaniac.venon.com [64.7.7.82]) by ns1.venon.com (Postfix) with ESMTP id 6A95AD1483; Sun, 3 Sep 2000 17:54:25 -0400 (EDT) Message-Id: <4.3.2.7.2.20000903175309.00b12658@mail.megapathdsl.net> X-Sender: (Unverified) X-Mailer: QUALCOMM Windows Eudora Version 4.3.2 Date: Sun, 03 Sep 2000 17:55:12 -0400 To: Danny , freebsd-questions@FreeBSD.ORG From: Allen Landsidel Subject: Re: MySQL FOREIGN KEYS In-Reply-To: <00090407430402.00345@freebsd.freebsd.org> Mime-Version: 1.0 Content-Type: text/plain; charset="us-ascii"; format=flowed Sender: owner-freebsd-questions@FreeBSD.ORG Precedence: bulk X-Loop: FreeBSD.ORG 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