INSERT DELAYED...SELECT... doesn't delay?
Hello, I'm trying to use the DELAYED keyword with an INSERT ... SELECT statement but it seems to ignore the DELAYED. Does anyone know if this is or is not supposed to work? Exmple: session 1 session 2 --- -- create table junk (value int); create table junk2 (value int); lock table junk read; insert into junk2 values (1); insert delayed into junk values (2); insert delayed into junk select value from junk2; unlock tables; http://www.mysql.com/doc/I/N/INSERT_SELECT.html http://www.mysql.com/doc/I/N/INSERT_DELAYED.html Thanks, Emery - 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
Redhat rpm of latest mysql server?
All, It looks to me like the latest rpm available from Redhat is 3.23.36 (mysql-server-3.23.36-1). I have it installed on my RedHat 7.1 system but it appears to have a replication bug of some sort. This bug is reportedly fixed in later versions. A rpm with a more recent version is available from MySQL (MySQL-3.23.40-1) but the difference in the names causes the package manager grief with it starts checking dependencies. Is there some way to get this to work? TIA, Emery - 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