Tengo un requisito: hay 4 variables y quiero todas las combinaciones de 4 variables e insertarlas en la tabla temporal.
DECLARE StartDateTime DATETIME; DECLARE Age INT; DECLARE Duration INT ; DECLARE TotalDD INT; CREATE TEMPORARY TABLE tempTable( Duration INT, TotalDD INT, Age INT, StartDateTime DATETIME, ); SET Age = 16; SET TotalDD = 14; SET Duration = 30; SET StartDateTime = CURDATE();Resultado exceptuado:
Duration age TotalDD StartDateTime 30 null null null null 16 null null 30 null null null 30 16 null null null null 14 20200622 30 null 14 null 30 16 null 20200622........... .......... pronto
Por favor ayúdame con esto
Creo que quieres una cross join :
select * from (select 16 as age union all select null) a cross join (select 14 as totaldd union all select null) t cross join (select 30 as duration union all select null) d cross join (select CURDATE() as StartDateTime union all select null) s