From owner-freebsd-questions Sun Sep 3 15: 7:49 2000 Delivered-To: freebsd-questions@freebsd.org Received: from dnai.com (dnai.com [207.181.194.98]) by hub.freebsd.org (Postfix) with ESMTP id 90F5437B42C for ; Sun, 3 Sep 2000 15:07:45 -0700 (PDT) Received: from azoth.dnai.com (azoth.dnai.com [207.181.194.94]) by dnai.com (8.9.3/8.9.3) with ESMTP id PAA73261 for ; Sun, 3 Sep 2000 15:07:45 -0700 (PDT) Received: from [192.168.100.2] (dnai-216-15-121-62.cust.dnai.com [216.15.121.62]) by azoth.dnai.com (8.9.3/8.9.3) with ESMTP id PAA69835 for ; Sun, 3 Sep 2000 15:07:44 -0700 (PDT) Mime-Version: 1.0 X-Sender: stevenl@pop.dnai.com Message-Id: In-Reply-To: <00090407430402.00345@freebsd.freebsd.org> References: <00090407430402.00345@freebsd.freebsd.org> Date: Sun, 3 Sep 2000 15:07:40 -0700 To: freebsd-questions@FreeBSD.ORG From: Steve Leibel Subject: Re: MySQL FOREIGN KEYS Content-Type: text/plain; charset="us-ascii" ; format="flowed" Sender: owner-freebsd-questions@FreeBSD.ORG Precedence: bulk X-Loop: FreeBSD.ORG At 7:36 AM +1100 9/4/00, Danny wrote: >-- >I am rnning mysql on FreeBSD 3.3 >- I type in the following cliche example of a database > >CREATE TABLE Customer (Customer_ID INT NOT NULL AUTO_INCREMENT, >Customer_Name varchar(20), >Customer_Address varchar(50), >Customer_Email varchar(50), > >PRIMARY KEY (Customer_ID)) >; > >CREaTE TABLE Agent (Agent_ID INT NOT NULL AUTO_INCREMENT, >Agent_Name varchar(20), >Agent_Address varchar(50), >Agent_Email varchar(50), > >PRIMARY KEY (Agent_ID)) > >; > >CREATE TABLE Assign (Assign_ID INT NOT NULL AUTO_INCREMENT, >Customer_ID INT, >Agent_ID INT, > >PRIMARY KEY (Assign_ID), > >FOREIGN KEY (Customer_ID) FROM Customer >ON UPDATE CASCADE, > >FOREIGN KEY (Agent_ID) FROM Agent >ON UPDATE CASCADE, > >) >; > > >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? mysql is not even a relational database by some definitions. It does not support transactions, subqueries, or triggers. An excellent open-source alternative is Postgres. I realize many people love mysql. People experienced with more fully functional database systems are generally dismayed to find that the "popular" mysql is lacking essential features. Steve L To Unsubscribe: send mail to majordomo@FreeBSD.org with "unsubscribe freebsd-questions" in the body of the message