首页 \ 问答 \ 从表mysql中选择子记录(Select child records from tables mysql)

从表mysql中选择子记录(Select child records from tables mysql)

 我得到了第二级儿童记录的选择声明，有更深入的问题，任何人都可以帮忙吗？  
SELECT
  id_mobile AS ID_PROJETO,
  UM.qtd_UC,
  AM.qtd_AMBIENTE
FROM projetos_mobile AS PM
LEFT JOIN (
   SELECT
      COUNT(id) AS qtd_UC,
      projeto,
      data_hora_importacao,
      id_uc_mobile
   FROM ucs_mobile
   WHERE data_hora_importacao = '2015-05-15 17:21:02'
   GROUP BY projeto) AS UM
ON PM.id_mobile = UM.projeto
LEFT JOIN (
   SELECT
      COUNT(id_uc_mobile) AS qtd_AMBIENTE,
      id_uc_mobile
   FROM ucs_mobile
   LEFT JOIN (
      SELECT
         uc
      FROM ambientes_mobile AS s
      WHERE data_hora_importacao = '2015-05-15 17:21:02') AS G
   ON G.uc = ucs_mobile.id_uc_mobile
   WHERE data_hora_importacao = '2015-05-15 17:21:02') AS AM
ON UM.id_uc_mobile = AM.id_uc_mobile
WHERE PM.data_hora_importacao = '2015-05-15 17:21:02'
 
 http://sqlfiddle.com/#!9/2eecf  
 如果有人想尝试一个解决方案，这里是一个sqlfiddle。 我有特定的等级：projeto> uc> ambiente> secao> medicoes  
ucs_mobile.projeto refers to projetos_mobile.id_mobile
ambientes_mobile.uc refers to ucs_mobile.id_uc_mobile
secoes_iluminacao_mobile.ambiente refers to ambientes_mobile.id_ambiente_mobile
 
 我需要为我传递的父项计算每个子项，我将有5个函数返回给定父项的每个子项的计数，例如，对于一个projeto父项我应该有计数（ucs），count（ambientes），计数（secoes），计数（medicoes）  
 所以，希望你们能帮助我。 数据库很难看，但这就是我得到的。 感谢任何帮助。 

I got the bellow piece of select statement that got level 2 child records, having problems to got deeper, can anyone help out? 
SELECT
  id_mobile AS ID_PROJETO,
  UM.qtd_UC,
  AM.qtd_AMBIENTE
FROM projetos_mobile AS PM
LEFT JOIN (
   SELECT
      COUNT(id) AS qtd_UC,
      projeto,
      data_hora_importacao,
      id_uc_mobile
   FROM ucs_mobile
   WHERE data_hora_importacao = '2015-05-15 17:21:02'
   GROUP BY projeto) AS UM
ON PM.id_mobile = UM.projeto
LEFT JOIN (
   SELECT
      COUNT(id_uc_mobile) AS qtd_AMBIENTE,
      id_uc_mobile
   FROM ucs_mobile
   LEFT JOIN (
      SELECT
         uc
      FROM ambientes_mobile AS s
      WHERE data_hora_importacao = '2015-05-15 17:21:02') AS G
   ON G.uc = ucs_mobile.id_uc_mobile
   WHERE data_hora_importacao = '2015-05-15 17:21:02') AS AM
ON UM.id_uc_mobile = AM.id_uc_mobile
WHERE PM.data_hora_importacao = '2015-05-15 17:21:02'
 
http://sqlfiddle.com/#!9/2eecf 
here is a sqlfiddle if anyone want to try a solution. I have the specific hierarchy: projeto>uc>ambiente>secao>medicoes 
ucs_mobile.projeto refers to projetos_mobile.id_mobile
ambientes_mobile.uc refers to ucs_mobile.id_uc_mobile
secoes_iluminacao_mobile.ambiente refers to ambientes_mobile.id_ambiente_mobile
 
I need a count of each child for the parent I pass, I will have 5 functions that return the count of each child for a given parent, for example, for a projeto parent I should have count(ucs),count(ambientes),count(secoes),count(medicoes) 
So, hope you guys can help me. The database is terrible ugly but that's is what I got. Appreciate any help.

原文：https://stackoverflow.com/questions/30356797

更新时间：2023-07-21 06:07

最满意答案

 实际上Boost确实有这样的适配器： boost::adaptors::reverse 。  
#include <list>
#include <iostream>
#include <boost/range/adaptor/reversed.hpp>

int main()
{
    std::list<int> x { 2, 3, 5, 7, 11, 13, 17, 19 };
    for (auto i : boost::adaptors::reverse(x))
        std::cout << i << '\n';
    for (auto i : x)
        std::cout << i << '\n';
}

Actually Boost does have such adaptor: boost::adaptors::reverse.  
#include <list>
#include <iostream>
#include <boost/range/adaptor/reversed.hpp>

int main()
{
    std::list<int> x { 2, 3, 5, 7, 11, 13, 17, 19 };
    for (auto i : boost::adaptors::reverse(x))
        std::cout << i << '\n';
    for (auto i : x)
        std::cout << i << '\n';
}

从表mysql中选择子记录(Select child records from tables mysql)

最满意答案

相关问答

C ++ 11反向范围的for-loop(C++11 reverse range-based for-loop)[2022-05-30]

C ++ 11基于范围的for循环，没有循环变量(C++11 range-based for loops without loop variable)[2022-06-14]

C ++ 11基于范围的for-loop效率“const auto＆i”与“auto i”(C++11 Range-based for-loop efficiency “const auto &i” versus “auto i”)[2024-04-05]

为什么在C ++ 11的基于范围的情况下需要按值获取(Why is capturing by value needed in C++11's range-based for)[2022-03-07]

基于范围的for-loop over regex匹配？(Range-based for-loop over regex matches?)[2023-07-02]

C ++ 11基于范围的for循环派生对象(C++11 range-based for loop on derived objects)[2022-08-12]

基于范围的for循环中的C ++ 11重新声明(C++11 redeclaration in range-based for loop)[2024-02-01]

如何使用基于C ++ 11范围的QJsonArray(How to use C++11 range-based for with QJsonArray)[2023-09-13]

如何在char * argv []上执行基于范围的c ++ 11 for循环？(How to perform a range-based c++11 for loop on char* argv[]?)[2024-01-12]

基于范围的for循环可以与常量整数值一起使用（C ++ 11）(Can a range-based for-loop be used with a constant integer value (C++11))[2022-03-09]

相关文章

最新问答