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'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]