主页 / dba / 问题 / 163221
Accepted
Jayaprakash Nagarajan
Asked: 2017-02-05 06:31:01 +0800 CST

如何在 mysql 的单行中获得 2 行输出？

  • 772

我想从下面的查询输出中获取单行输出

select @@hostname,count(*) "RECOMMENDED_PATCHES" from test.PATCHES
union all
select @@hostname,count(*) "PATCH_VERSIONS" from test.PATCH_VERSIONS

output:
ct-test-02 79
ct-test-02 0

expected output:
ct-test-02 79 0
mysql

1 个回答

  1. Best Answer
    select @@hostname,  
(select count(*) from test.PATCHES) "RECOMMENDED_PATCHES",  
(select count(*) from test.PATCH_VERSIONS) "PATCH_VERSIONS"
    • 0

相关问题