***BOGO*** Re: Create Table from Results of SQL Query

["O. Olson" <olson_ord@xxxxxxxx>]

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 <dnelson@xxxxxxxxxxxxxxx> ha scritto:

> Da: Dan Nelson <dnelson@xxxxxxxxxxxxxxx>
> Oggetto: Re: Create Table from Results of SQL Query
> A: "O. Olson" <olson_ord@xxxxxxxx>
> Cc: mysql@xxxxxxxxxxxxxxx
> 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
> 	dnelson@xxxxxxxxxxxxxxx
> 
> -- 
> MySQL General Mailing List
> For list archives: http://lists.mysql.com/mysql
> To unsubscribe:   
> http://lists.mysql.com/mysql?unsub=olson_ord@xxxxxxxx


      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/mysql?unsub=royale@xxxxxxxxxx