Re: Problem with FETCH/INTO

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?

Yours,
Laurenz Albe Received on Tue Aug 05 2008 - 02:39:21 CDT