Hi! > I just come across this old email: > > On Thu, Mar 09, 2000 at 03:14:28PM +0200, sinisa wrote: > > > > This happens in the case when mysql does not have to create temporrary > > tables in order to obtain result set, but is reading from the live > > table itself. > > > > Changing a table during such reading operation would break things. > > It would be helpful if there was a simple efficient way to force > the use of a temporary table for these situations. > > Using an ORDER BY would be inefficient. Would adding "HAVING 1=1" > (without a group by) work? > > Tim. The SELECT option SQL_BUFFER_RESULT will force MySQL to create a temporary table for the results and unlock the other tables involved in the query as soon as all rows have been fetched. Regards, Monty --------------------------------------------------------------------- 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