如何将数据库中查询到的数据再加上一行自定义数据

Question

大家好，最近有一个问题想了好久就是想不到答案，不知怎么操作，想请各位江湖好汉出出注意！

列：表 test(id,name,age,gender,address,re)数据：id    name    age    gender   address   re
      1       Tom    20      male     5Street    NO
如果正常查询的话，应该是只有一条数据出来，我想是不是能够这样
ID      Name    Age    Gender    Address         Re
1 Tom 20 Male American This is a Girl
1 NULL NULL NULL NULL            NO
请问如果这样的话，就一个查询语句要怎么写呢？SQL拆分一条数据拆多条

Answer 1

create table test
(id int, name varchar(10), age int, 
 gender varchar(10), address varchar(10),
 re varchar(10))insert into test
 select 1, 'Tom', 20, 'male', '5Street', 'NO'
 select id,name,age,gender,address,re from test where id=1
union all
select id,null,null,null,null,re from test where id=1/*
id          name       age         gender     address    re
----------- ---------- ----------- ---------- ---------- ----------
1           Tom        20          male       5Street    NO
1           NULL       NULL        NULL       NULL       NO(2 row(s) affected)
*/

Answer 2

Sorry,我知道错误在哪了！    谢谢!

Answer 3

单据内码        产品代码                                                                             产品名称                                                                             产品型号                                                                                                                                                                                                                                                            产品单位                                                                             产品数量                           含税价                                      含税金额                    不含税价                                     不含税金额                                    税额                     税率                             折扣额                                                   
----------- -------------------------------------------------------------------------------- -------------------------------------------------------------------------------- --------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- -------------------------------------------------------------------------------- ------------------------------ ---------------------------------------- ----------------------- ---------------------------------------- ---------------------------------------- ---------------------- ------------------------------ ----------------------------------------------------- 
1070        03.11025006000                                                                   NULL                                                                             NULL                                                                                                                                                                                                                                                            NULL                                                                             NULL                           NULL                                     NULL                    NULL                                     NULL                                     NULL                   NULL                           500.0
1070        03.11025006000                                                                   钢质十字凸刀片                                                                          M2.5*6                                                                                                                                                                                                                                                          PCS                                                                              450.0000000000                 150.00000000000                          67500.0000              128.205128                               57692.31000000                           9807.6900              17.0000000000                  500.0
1070        03.21028009500                                                                   NULL                                                                             NULL                                                                                                                                                                                                                                                            NULL                                                                             NULL                           NULL                                     NULL                    NULL                                     NULL                                     NULL                   NULL                           500.0
1070        03.21028009500                                                                   十字凸刀片                                                                            φ2.8*9.5                                                                                                                                                                                                                                                        PCS                                                                              880.0000000000                 170.00000000000                          149600.0000             145.299145                               127863.25000000                          21736.7500             17.0000000000                  500.0
1070        03.21030002500                                                                   NULL                                                                             NULL                                                                                                                                                                                                                                                            NULL                                                                             NULL                           NULL                                     NULL                    NULL                                     NULL                                     NULL                   NULL                           500.0
1070        03.21030002500                                                                   六角刀母                                                                             M3                                                                                                                                                                                                                                                              PCS                                                                              1200.0000000000                167.00000000000                          200400.0000             142.735043                               171282.05000000                          29117.9500             17.0000000000                  500.0（所影响的行数为 6 行）
如果有多行的话，我想也就只加一行  不知道怎么实现？

Answer 4

create table test
(id int, name varchar(10), age int, 
 gender varchar(10), address varchar(10),
 re varchar(10))
 
insert into test
 select 1, 'Tom', 20, 'male', '5Street', 'NO' union all
 select 2, 'Mike', 21, 'male', '6Street', 'NO' union all
 select 3, 'Jone', 22, 'male', '7Street', 'NO'
select id,name,age,gender,address,re from test
union all
select id,null,null,null,null,re from test where id=1/*
id          name       age         gender     address    re
----------- ---------- ----------- ---------- ---------- ----------
1           Tom        20          male       5Street    NO
2           Mike       21          male       6Street    NO
3           Jone       22          male       7Street    NO
1           NULL       NULL        NULL       NULL       NO(4 row(s) affected)
*/

Answer 5

使用
union进行拼接查询，使用select 来自定义你的列
例如union 
    select 'column0','column1','column2','column3',...

Answer 6

/*
id          name       age         gender     address    re
----------- ---------- ----------- ---------- ---------- ----------
1           Tom        20          male       5Street    NO
1           Tom        20          male       5Street    NO
1           NULL       NULL        NULL       NULL       NO
2           Mike       21          male       6Street    NO
3           Jone       22          male       7Street    NO
 
(4 row(s) affected)
*/我想要的效果是这样的  相同的id  我只要加一行   现在有两个ID为1 的话   就会加两行