Date: Mon, 4 Sep 2000 08:26:53 +1100 From: Danny <dannyh@idx.com.au> To: Allen Landsidel <all@biosys.net>, freebsd-questions@FreeBSD.ORG Subject: Re: MySQL FOREIGN KEYS Message-ID: <00090408273703.00345@freebsd.freebsd.org> References: <4.3.2.7.2.20000903175309.00b12658@mail.megapathdsl.net>
next in thread | previous in thread | raw e-mail | index | archive | help
And in response to postgresql ican you install that using ports ? Is there a big learning curve between mysql and postsql? On Mon, 04 Sep 2000, Allen Landsidel wrote: > 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 -- 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?00090408273703.00345>