Re: Problem with FETCH/INTO
Date: 05 Aug 2008 07:39:21 GMT
Dan Blum <tool_at_panix.com> wrote:
>>> You can't fetch into a table. What you want there is a record collection.
>>> Unless of course you really want to copy records from one table to
>>> another, in which case you want to use INSERT INTO tblName2 SELECT FROM
>>> tblName1 ...
> >> Yeah. That's probably what I want except that it is a very big table, >> and I want to do it a few records at a time. Can I use the LIMIT >> modifier on an INSET INTO/ SELECT statement like that? > > Why do you want to do it a few records at a time?
Just guessing, but maybe the 10^8 or so records that the query yields would not fit into memory?
Laurenz Albe Received on Tue Aug 05 2008 - 02:39:21 CDT