From: O. Olson (olson_ordyahoo.it)
Date: Thu Jul 03 2008 - 22:58:54 CDT

• Messages sorted by: [ date ] [ thread ] [ subject ] [ author ]

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 <dnelsonallantgroup.com> ha scritto:

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

• Messages sorted by: [ date ] [ thread ] [ subject ] [ author ]