If you mean foreign key constraints, it's available with InnoDb tables under
MySQL, as are atomic transactions (commit and rollback). I'm using this
with MySQL4.0 and it works a treat :)
> -----Original Message-----
> From: Juliana Gubert Ehrensperger [mailto:juliana@stripped]
> Sent: 28 October 2003 14:50
> To: SQL List
> Subject: Foreigner keys in MySQL?
> Hello all,
> I'm joined to a research project and by now we need to specify a
> software to build a database.
> Although I don't have so much information about this kind of
> software, I've been considered MySQL a good option, as it's an open
> source database and this project has been developed in a public
> Nevertheless, I received the information that MySQL don't support
> relacional functions between tables of the same database. I'm not sure
> about this, and I'd like to confirm this information. Does MySQL allow
> relacionl functions between tables recognizing "foreign keys"?
> Excuse me for asking a so simple question,
> Juliana Gubert Ehrensperger
> Federal Univesity of Santa Catarina
> MySQL General Mailing List
> For list archives: http://lists.mysql.com/mysql
> To unsubscribe: http://lists.mysql.com/mysql?unsub=1