SELECT result into new table

Question

SELECT result into new table

Hello everyone knows how to add the result of your SELECT to a new table?

SELECT Postcode, Punten1, Punten2, Punten3, Punten4 FROM main_inboedel, ouderdom,
       levensfase, inkomen, oppervlakte
 WHERE main_inboedel.Ouderdomnummer = ouderdom.Ouderdomnummer
   AND main_inboedel.Levensfasenummer = levensfase.Levensfasenummer
   AND main_inboedel.Inkomennummer = inkomen.Inkomennummer
   AND main_inboedel.Oppervlaktenummer = oppervlakte.Oppervlaktenummer

+3

sql mysql

warnerst 28 jan. 13 at 11:01

source to share

2 answers

Rembunator · Answer 1 · 2013-01-28T11:02:56+0000

CREATE TABLE tablename AS SELECT field1,field2 FROM othertable;

DavidB · Answer 2 · 2013-01-28T11:02:27+0000

select *
into NEWTABLE
from OLDTABLE

SELECT result into new table

More articles: