为变量生成所有组合并插入temp表

dgiusagp 于 2021-08-09 发布在 Java

关注(0)|答案(1)|浏览(254)

我有一个要求，有4个变量，我想4个变量的所有组合，并插入临时表。

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();

例外结果：

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

........... .......... 等等
请帮帮我

sql mysql Database stored-procedures

来源：https://stackoverflow.com/questions/62499847/generate-all-combinations-for-variables-and-insert-into-temp-table

1条答案

按热度按时间

sshcrbum1#

我想你想要一个 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

赞(0）回复(0）举报 2021-08-09

我来回答

为变量生成所有组合并插入temp表

1条答案

相关问题

热门标签

最新问答