Hi Guys,
http://www.mysql.com/doc/R/e/Replication_Features.html ... states that last_insert_id() will be replicated "correctly". However I don't think this is always the case, for instance: INSERT INTO TABLE tab1 (field1) values ("Test"); INSERT INTO TABLE tab2 (somefield) values (last_insert_id()); Will replicate properly *ONLY IF* tab1 is being replicated by the slave. If tab1 is not being replicated then the value inserted into somefield on tab2 will not match that on the server. This is with 3.23.47 at least. Is this a bug or simply that my definition of "correctly" does not match yours? :) Regards, Chris -- Chris Wilson <[EMAIL PROTECTED]> http://www.wapmx.com --------------------------------------------------------------------- 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
