Thanks Dan for your quick response - it works now. I am new to SQL in general and MySQL in
--- 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
> Note that you may need to add appropriate indexes after
> this, to make
> your later queries on the temp table faster.
> Dan Nelson
> MySQL General Mailing List
> For list archives: http://lists.mysql.com/mysql
> To unsubscribe:
Posta, news, sport, oroscopo: tutto in
> una sola pagina.
Crea l'home page che piace a te!