Date: Sun, 3 Sep 2000 15:07:40 -0700 From: Steve Leibel <stevel@bluetuna.com> To: freebsd-questions@FreeBSD.ORG Subject: Re: MySQL FOREIGN KEYS Message-ID: <v04210121b5d87b839b24@[192.168.100.2]> In-Reply-To: <00090407430402.00345@freebsd.freebsd.org> References: <00090407430402.00345@freebsd.freebsd.org>
next in thread | previous in thread | raw e-mail | index | archive | help
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
Want to link to this message? Use this URL: <https://mail-archive.FreeBSD.org/cgi/mid.cgi?v04210121b5d87b839b24>