Re: Problem with FETCH/INTO
From: Dan Blum <tool_at_panix.com>
Date: Tue, 5 Aug 2008 02:37:03 +0000 (UTC)
Message-ID: <g78ecf$lon$1@reader1.panix.com>
Date: Tue, 5 Aug 2008 02:37:03 +0000 (UTC)
Message-ID: <g78ecf$lon$1@reader1.panix.com>
Jack <k314159265_at_gmail.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?
-- _______________________________________________________________________ Dan Blum tool_at_panix.com "I wouldn't have believed it myself if I hadn't just made it up."Received on Mon Aug 04 2008 - 21:37:03 CDT