From: Thimble Smith
Date: March 20 1999 7:08pm
Subject: Re: Help with query, plz
List-Archive: http://lists.mysql.com/mysql/697
Message-Id: <19990320120848.N17225@desert.net>
MIME-Version: 1.0
Content-Type: text/plain; charset=us-ascii

On Sat, Mar 20, 1999 at 08:03:24PM +0100, Michal Ludvig wrote:
> Hmm, my version of MySQL (3.22.19a) seems to support only 
> "SELECT ip INTO OUTFILE xxx ...". What a pitty! Has it changed in 3.22.20?

It's:

INSERT INTO tmp_table SELECT ...


> I hope not via a cycle  "$i=0; while ($sth->fetchrow()) {$i++;}" ...

No, you can do:  $sth->rows;  But make sure that you are using
mysql_store_result (the default), and not mysql_use_result.

Tim