Hi everyone. Does anybody know if it is possible to commit only partially ? example:
query: select ... from A ... for update; // update fields locked in A query: select ... from B ... for update; then I would like to commit all changes I did in the locked records from table A, without releasing locks put on records from table B. nb: I am using the InnoDb engine. Thanks. Erwan --------------------------------------------------------------------- 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