Re: Problem with FETCH/INTO

From: Laurenz Albe <>
Date: 05 Aug 2008 07:39:21 GMT
Message-ID: <>

Dan Blum <> 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

Original text of this message