On Wednesday, April 25, 2001, at 07:02 PM, Neil Lunn wrote:
>> both return a single row indicating success or failure. The last
>> two return a row for each record in the table. You'd probably be
>> less than thrilled if you have a few million records.
>
> No these means do not return any rows. They return sucess or
> faliure with
> initiating
> a fetch. In fact no DBMS will return any rows whether there is
> one record or
> millions until a fetch is called.
>
> A good DBMS will actually fail the statement at the prepare stage.
I'm sure you're right. I just entered the commands straight into
the MySQL command line on my home system instead of thinking
about what DBI would do.
My mistake.
Mike Schienle
Interactive Visuals, Inc.
http://www.ivsoftware.com