Create Table from Results of SQL Query

[O. Olson]

Hi,

I have a SQL Query that has an inner join and it is taking too long to 
execute. I am thinking of  speeding this up by dumping the result into a 
separate table – as I would be requiring the result of this query many times in 
the future. 
I am wondering if someone could show me how to create a table from the 
results of the SQL Query. 

I hope I have explained that correctly. I am ready to provide more 
explanation if you feel that is necessary. Thanks a lot to those of you who 
help.

Thanks,
O.O. 



  Posta, news, sport, oroscopo: tutto in una sola pagina. 
Crea l#39;home page che piace a te!
www.yahoo.it/latuapagina

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

Re: Create Table from Results of SQL Query

[O. Olson]

Thanks Dan for your quick response - it works now. I am new to SQL in general 
and MySQL in particular. 
O.O. 



--- Ven 4/7/08, Dan Nelson [EMAIL PROTECTED] ha scritto:

 Da: Dan Nelson [EMAIL PROTECTED]
 Oggetto: Re: Create Table from Results of SQL Query
 A: O. Olson [EMAIL PROTECTED]
 Cc: mysql@lists.mysql.com
 Data: Venerdì 4 luglio 2008, 05:11
 In the last episode (Jul 04), O. Olson said: I have a SQL
 Query that
  has an inner join and it is taking too long to
 execute. I am thinking
  of speeding this up by dumping the result into a
 separate table - as
  I would be requiring the result of this query many
 times in the
  future.  I am wondering if someone could show me how
 to create a
  table from the results of the SQL Query.
 
 CREATE TABLE table2 SELECT field1,field2 FROM table1
 
 http://dev.mysql.com/doc/refman/5.0/en/create-table.html
 
 Note that you may need to add appropriate indexes after
 this, to make
 your later queries on the temp table faster.
 
 -- 
   Dan Nelson
   [EMAIL PROTECTED]
 
 -- 
 MySQL General Mailing List
 For list archives: http://lists.mysql.com/mysql
 To unsubscribe:   
 http://lists.mysql.com/[EMAIL PROTECTED]


  Posta, news, sport, oroscopo: tutto in una sola pagina. 
Crea l#39;home page che piace a te!
www.yahoo.it/latuapagina

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