From: Ed Carp Date: March 20 1999 7:19pm Subject: Re: Help with query, plz List-Archive: http://lists.mysql.com/mysql/698 Message-Id: <003201be7306$98359900$74c9a8c0@traveler.airmail.net> MIME-Version: 1.0 Content-Type: text/plain; charset="iso-8859-1" Content-Transfer-Encoding: 7bit >> 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 ... Oops, you're right, I was running the query from Access and pasted the cut buffer from Access instead of the log file.