The MySQL documentation says: "To ensure that the update log/binary log can be used to re-create the original tables, MySQL will not allow concurrent inserts during INSERT .... SELECT"
Does this mean: A. An INSERT...SELECT cannot run if any other SELECT is running on the table OR B. An INSERT...SELECT cannot run if another INSERT...SELECT is already running on the table Which is correct? The wording of the documentation suggests that B is correct, but my actual tests on the server indicate A is correct (MySQL 3.23.43 RH Linux 7.1) Thanks --------------------------------------------------------------------- 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
