select do tabulky

zdeniatqo · Napísal **zdeniatqo**: 26.06.2011 13:32 | select do tabulky

Ahojte

,

potrebovala by som mensiu radu....
ako sa da select ulozit ako tabulka? konkretne sa jedna o select

SELECT caller,
called,
sum(duration),
sum(duration_unit_count),
sum(free_unit_count),
sum(paid_unit_count)
FROM data
GROUP BY caller;

vopred vdaka

emer · Napísal **emer**: 26.06.2011 14:16 | select do tabulky

Kód:

CREATE TABLE nova_tab (caller char(10), called char(10), sum_duration int(10) ... ); #doplnis ostatne stlpce

INSERT INTO nova_tab SELECT caller, 
 called, 
 sum(duration), 
 sum(duration_unit_count), 
 sum(free_unit_count), 
 sum(paid_unit_count) 
FROM data 
GROUP BY caller;

zdeniatqo · Napísal autor témy **zdeniatqo**: 26.06.2011 14:44 | select do tabulky

vdaka

select do tabulky

select do tabulky

Podobné témy

mysql: 2 tabulky - jeden select

ako v select v joine vybrat field tabulky ?

formular: presun <option> zo <select> do <select>

select

Select

SELECT

select

SELECT OPTION

select datetime

SELECT DISTINCT

Komplikovany select

Select porovnanie

Multi select

Stromový select

MySQL Select

Select script