From: Thimble Smith
Date: April 9 1999 7:43pm
Subject: Re: SQL w/ multiple tables question
List-Archive: http://lists.mysql.com/mysql/1612
Message-Id: <19990409124335.A9369@desert.net>
MIME-Version: 1.0
Content-Type: text/plain; charset=us-ascii

On Fri, Apr 09, 1999 at 08:29:27PM +0100, Daniel Gardner wrote:
> Create a temporary table which contains all of the records, and do your
> select on that. This isn't that easy with mysql as you'd have to do three
> SELECT INTO's and then three LOAD DATA's - very inefficient. Not nice.
> Horrible.

No, you can do three INSERT INTO temporary SELECT x, y, z FROM table
instead.

I do agree that it's better to reorganize the data, though.

Tim