<blockquote>>The only nice aspect of FOREIGN KEY is that it gives ODBC and some
</blockquote>
other client programs the ability to see how a table is connected and
to use this to show connection diagrams and to help in building
applicatons<<
I've always wondered whether there was some fundamental stupidity lurking behind the scenes within the MySQL camp that makes them unable to understand ACID issues...