> -----Original Message----- > From: [EMAIL PROTECTED] > [mailto:[EMAIL PROTECTED] On Behalf Of Dave Cross > Sent: 22 August 2003 14:21 > To: [EMAIL PROTECTED] > Subject: Re: [OT] SQL woes > > > MySQL is just a file-based storage system with a pseudo-SQL > interface. It doesn't support many of the things that you'd > expect in a real SQL implementation, for example: > > * Transactions > > * Subselects > > * Referential integrity >
Not sure about the referential integrity but it does have transactions and subselects are coming in 4.1. (Currently 4.0.14) "MySQL Server (version 3.23-max and all versions 4.0 and above) supports transactions with the InnoDB and BDB Transactional storage engines. InnoDB provides full ACID compliance" [0] Andy [0] http://www.mysql.com/doc/en/ANSI_diff_Transactions.html