Re: Problem with FETCH/INTO

From: Jack <>
Date: Mon, 4 Aug 2008 18:14:18 -0700 (PDT)
Message-ID: <>

> 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

Original text of this message