Hi, 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 :)
Thanks, Mike > -----Original Message----- > From: Juliana Gubert Ehrensperger [mailto:[EMAIL PROTECTED] > 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 > university. > 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 > Brazil > _________________________________________ > > > > -- > MySQL General Mailing List > For list archives: http://lists.mysql.com/mysql > To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED] > > > > -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]