Doesn't foreign keys only work with InnoDB talbes? And Although you can create relationships it doesn't enforce any kind of referential integrity?
-----Original Message----- From: Robert Chartier [mailto:[EMAIL PROTECTED]] Sent: Friday, August 02, 2002 8:51 AM To: ActiveServerPages Subject: RE: Is MySQL a True Relational DB? im sure this was posted during the last conversation, but if not, ill add it now. http://openacs.org/philosophy/why-not-mysql.html At 10:46 AM 8/2/2002 -0500, you wrote: >Thanks guys. Yes. That was it. That's what stuck out in my head. Someone >had said that it didn't support foreign keys, and therefore, it wasn't a >true relational database. > >According to BT, it does, so it is. Thanks! > > > > > -----BEGIN PGP SIGNED MESSAGE----- > > Hash: SHA1 > > > > Yes, mySQL has the ability to define foreign keys, which allows you > > to RELATE tables together. It does lack some of the nicer SQL > > features tho, like correlated subqueries, transactions and stored > > procedures. I believe they added transactions and stored procs to > > 4.0. However, it is a great database to work with. > > > > Ben Timby > > Webexcellence > > PH: 317.423.3548 x23 > > TF: 800.808.6332 x23 > > FX: 317.423.8735 > > [EMAIL PROTECTED] > > www.webexc.com > > > > - -----Original Message----- > > From: 15Seconds Editor [mailto:[EMAIL PROTECTED]] > > Sent: Friday, August 02, 2002 7:53 AM > > To: ActiveServerPages > > Subject: Is MySQL a True Relational DB? > > > > > > Guys, > > > > I remember a discussion a while ago that debated whether or not MYSQL > > is a > > true relational database. I cannot seem to find that discussion in > > the > > archives. > > > > At risk of stirring up the debate again (which may not necessarily be > > a > > bad thing), can someone tell me if MySQL is or is not a true > > relational > > database? The last discussion concluded that it isn't. Don't remember > > why > > though. > > > > Thanks! > > > > - --- > > You are currently subscribed to activeserverpages as: [EMAIL PROTECTED] > > To unsubscribe send a blank email to > > %%email.unsub%% > > > > -----BEGIN PGP SIGNATURE----- > > Version: PGP 7.0.4 > > > > iQA/AwUBPUrCSfnby1cCm2Q8EQIQAwCg5oh1c0hyR/6svHrCndhHmhrX9WgAoLNT > > KukVb2hSIKAGb3SjYKMh2r6X > > =PYvg > > -----END PGP SIGNATURE----- > >--- >You are currently subscribed to activeserverpages as: [EMAIL PROTECTED] >To unsubscribe send a blank email to >%%email.unsub%% Robert Chartier Author and Developer 604-975-5590 [EMAIL PROTECTED] http://www.aspalliance.com/nothingmn/ --- You are currently subscribed to activeserverpages as: [EMAIL PROTECTED] To unsubscribe send a blank email to %%email.unsub%% --- You are currently subscribed to activeserverpages as: [email protected] To unsubscribe send a blank email to [EMAIL PROTECTED]
