Hi Ben, > > Some database engineers would say MySQL isn't a database > because it has no > > transactions by know (in a stable version). > > > But think about, if you really need this!!! > > Very much so! > > With dependent foreign key constraints that are being developed by > MySQL, you have to use delayed constraint checking in the form of a > transaction, or with cyclic references, you can never add > data to your > tables :)
ok, you're right! But there are possible other ways to solve this. You possibly could take care by your program. In our project we have no problems like this because we use different tables for input and output. We use unique keys so that theres no corrupted data. Regards Reiner --------------------------------------------------------------------- Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
