INSERT ... SELECT ON DUPLICATE

--0-84066196-1253855300=:14350
Content-Type: text/plain; charset=us-ascii

Does anyone know if I can add a hint SQL_BUFFER_RESULT to INSERT .. SELECT ON DUPLICATE

ex..

INSERT INTO foo
SELECT SQL_BUFFER_RESULT* FROM bar
ON DUPLICATE KEY UPDATE foo.X=..

Both my tables foo and bar are InnoDB; but the idea is to release the lock on bar as soon as possible by moving the results to temp table to accommodate slow inserts..

Any reco or does SQL_BUFFER_RESULT work in this case ?

Thanks





--0-84066196-1253855300=:14350--