Date: Sun, 03 Sep 2000 17:55:12 -0400 From: Allen Landsidel <all@biosys.net> To: Danny <dannyh@idx.com.au>, freebsd-questions@FreeBSD.ORG Subject: Re: MySQL FOREIGN KEYS Message-ID: <4.3.2.7.2.20000903175309.00b12658@mail.megapathdsl.net> In-Reply-To: <00090407430402.00345@freebsd.freebsd.org>
next in thread | previous in thread | raw e-mail | index | archive | help
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
Want to link to this message? Use this URL: <https://mail-archive.FreeBSD.org/cgi/mid.cgi?4.3.2.7.2.20000903175309.00b12658>