Skip site navigation (1)Skip section navigation (2)
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>