Home Esplora Aiuto
Registrati Accedi
xuyiping
/
docker-compose
1
0
Forka 0
File Problemi 0 Pull Requests 0 Wiki
Ramo (Branch): master
Rami (Branch) Tag
docker-compose
/
mysql5.7
/
mysql
/
data
/
heatwatch
/
v_v_milksale.frm

v_v_milksale.frm 1.0 KB
Permalink Cronologia Originale

123456789101112131415 
  1. TYPE=VIEW
    2. 

  2. query=select `heatwatch`.`milksale`.`intPastureId` AS `intPastureId`,`heatwatch`.`milksale`.`dateOddDate` AS `dateOddDate`,sum(`heatwatch`.`milksale`.`decWeight`) AS `sale_wt` from `heatwatch`.`milksale` group by `heatwatch`.`milksale`.`intPastureId`,`heatwatch`.`milksale`.`dateOddDate`
    3. 

  3. md5=ab6b337d267c92bcebde97b856d44014
    4. 

  4. updatable=0
    5. 

  5. algorithm=0
    6. 

  6. definer_user=roo
    7. 

  7. definer_host=%
    8. 

  8. suid=1
    9. 

  9. with_check_option=0
    10. 

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

  11. create-version=1
    12. 

  12. source=select `milksale`.`intPastureId` AS `intPastureId`,`milksale`.`dateOddDate` AS `dateOddDate`,sum(`milksale`.`decWeight`) AS `sale_wt` from `milksale` group by `milksale`.`intPastureId`,`milksale`.`dateOddDate`
    13. 

  13. client_cs_name=utf8
    14. 

  14. connection_cl_name=utf8_general_ci
    15. 

  15. view_body_utf8=select `heatwatch`.`milksale`.`intPastureId` AS `intPastureId`,`heatwatch`.`milksale`.`dateOddDate` AS `dateOddDate`,sum(`heatwatch`.`milksale`.`decWeight`) AS `sale_wt` from `heatwatch`.`milksale` group by `heatwatch`.`milksale`.`intPastureId`,`heatwatch`.`milksale`.`dateOddDate`
    16.