List:General Discussion« Previous MessageNext Message »
From:Thimble Smith Date:April 9 1999 7:43pm
Subject:Re: SQL w/ multiple tables question
View as plain text  
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
Thread
SQL w/ multiple tables questionDoug Ledbetter9 Apr
Re: SQL w/ multiple tables questionDoug Ledbetter9 Apr
RE: SQL w/ multiple tables questionDaniel Gardner9 Apr
  • Re: SQL w/ multiple tables questionThimble Smith9 Apr