List:General Discussion« Previous MessageNext Message »
From:O. Olson Date:July 4 2008 3:58am
Subject:Re: Create Table from Results of SQL Query
View as plain text  
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@stripped> ha scritto:

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


      Posta, news, sport, oroscopo: tutto in
> una sola pagina. 
Crea l&#39;home page che piace a te!
www.yahoo.it/latuapagina
Thread
Create Table from Results of SQL QueryO. Olson4 Jul
  • Re: Create Table from Results of SQL QueryDan Nelson4 Jul
    • Re: Create Table from Results of SQL QueryO. Olson4 Jul