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
