Re: Problem with FETCH/INTO
From: Jack <k314159265_at_gmail.com>
Date: Mon, 4 Aug 2008 18:14:18 -0700 (PDT)
Message-ID: <1e2a890e-a395-48e3-b326-9afd33b0a012@r15g2000prd.googlegroups.com>
Date: Mon, 4 Aug 2008 18:14:18 -0700 (PDT)
Message-ID: <1e2a890e-a395-48e3-b326-9afd33b0a012@r15g2000prd.googlegroups.com>
> 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? Received on Mon Aug 04 2008 - 20:14:18 CDT