Re: Working around Insert ... Select

[Michael Stassen]

Perhaps I'm misunderstanding what you want, but could you create your 
temporary table as the result of your construct, then insert it into 
your table?  If I'm reading you correctly, I think that would involve 
less data in the temporary table, so might be faster overall.  Something 
like:

  CREATE TEMPORARY TABLE results SELECT ..construct..

  INSERT INTO large_table SELECT * FROM results

If that's not helpful, and no one else has a better suggestion, you 
might try posting the queries you're considering along with a little 
more info.

Michael

Boyd E. Hemphill wrote:

Hello to all:
 
I am attempting to move two columns of data into a large table by using
the insert into . select .  construct.  My problem is that I need to
join to the table I am inserting to.  To get around this my idea is to
create a temporary database and populate it with the table then join to
this temporary table.  
 
While this will work (the table is static) it will take a long time.
Does anyone have a better solution?
 
Thank you for your time!
 
 
Best Regards,
Boyd E. Hemphill
[EMAIL PROTECTED]
Triand, Inc.

Life is not a journey to the grave arriving safely in a well preserved
body, but rather a skid in broadside, thoroughly used, totally worn, and
loudly proclaiming:  "WOW!  What a ride!"
 



--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:    http://lists.mysql.com/[EMAIL PROTECTED]