Domů Procházet Nápověda
Registrovat se Přihlásit se
xuyiping
/
docker-compose
1
0
Rozštěpit 0
Soubory Úkoly 0 Pull Requesty 0 Wiki
Větev: master
Větve Značky
docker-compose
/
mysql5.7
/
mysql
/
data
/
heatwatch
/
vr_reproduc.frm

vr_reproduc.frm 2.7 KB
Trvalý odkaz Historie Surový

123456789101112131415 
  1. TYPE=VIEW
    2. 

  2. query=select cast(substring_index(group_concat(`heatwatch`.`eventcount`.`id` order by `heatwatch`.`eventcount`.`id` DESC separator \',\'),\',\',1) as signed) AS `stid`,`heatwatch`.`eventcount`.`name` AS `name`,substring_index(group_concat(`heatwatch`.`eventcount`.`todayTotal` order by `heatwatch`.`eventcount`.`id` DESC separator \',\'),\',\',1) AS `today_no`,substring_index(group_concat(`heatwatch`.`eventcount`.`monthTotal` order by `heatwatch`.`eventcount`.`id` DESC separator \',\'),\',\',1) AS `month_no`,`heatwatch`.`eventcount`.`intPastureId` AS `intPastureId` from `heatwatch`.`eventcount` where (`heatwatch`.`eventcount`.`type` = \'繁殖情况\') group by `heatwatch`.`eventcount`.`name`,`heatwatch`.`eventcount`.`intPastureId` order by cast(substring_index(group_concat(`heatwatch`.`eventcount`.`id` order by `heatwatch`.`eventcount`.`id` DESC separator \',\'),\',\',1) as signed)
    3. 

  3. md5=c042e594a17c5d149788570b439aaee7
    4. 

  4. updatable=0
    5. 

  5. algorithm=0
    6. 

  6. definer_user=root
    7. 

  7. definer_host=localhost
    8. 

  8. suid=1
    9. 

  9. with_check_option=0
    10. 

  10. timestamp=2022-12-14 10:07:38
    11. 

  11. create-version=1
    12. 

  12. source=select cast(substring_index(group_concat(`eventcount`.`id` order by `eventcount`.`id` DESC separator \',\'),\',\',1) as signed) AS `stid`,`eventcount`.`name` AS `name`,substring_index(group_concat(`eventcount`.`todayTotal` order by `eventcount`.`id` DESC separator \',\'),\',\',1) AS `today_no`,substring_index(group_concat(`eventcount`.`monthTotal` order by `eventcount`.`id` DESC separator \',\'),\',\',1) AS `month_no`,`eventcount`.`intPastureId` AS `intPastureId` from `eventcount` where `eventcount`.`type` = \'繁殖情况\' group by `eventcount`.`name`,`eventcount`.`intPastureId` order by cast(substring_index(group_concat(`eventcount`.`id` order by `eventcount`.`id` DESC separator \',\'),\',\',1) as signed)
    13. 

  13. client_cs_name=utf8
    14. 

  14. connection_cl_name=utf8_general_ci
    15. 

  15. view_body_utf8=select cast(substring_index(group_concat(`heatwatch`.`eventcount`.`id` order by `heatwatch`.`eventcount`.`id` DESC separator \',\'),\',\',1) as signed) AS `stid`,`heatwatch`.`eventcount`.`name` AS `name`,substring_index(group_concat(`heatwatch`.`eventcount`.`todayTotal` order by `heatwatch`.`eventcount`.`id` DESC separator \',\'),\',\',1) AS `today_no`,substring_index(group_concat(`heatwatch`.`eventcount`.`monthTotal` order by `heatwatch`.`eventcount`.`id` DESC separator \',\'),\',\',1) AS `month_no`,`heatwatch`.`eventcount`.`intPastureId` AS `intPastureId` from `heatwatch`.`eventcount` where (`heatwatch`.`eventcount`.`type` = \'繁殖情况\') group by `heatwatch`.`eventcount`.`name`,`heatwatch`.`eventcount`.`intPastureId` order by cast(substring_index(group_concat(`heatwatch`.`eventcount`.`id` order by `heatwatch`.`eventcount`.`id` DESC separator \',\'),\',\',1) as signed)
    16.