| 123456789101112131415 |
- TYPE=VIEW
- 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`
- md5=ab6b337d267c92bcebde97b856d44014
- updatable=0
- algorithm=0
- definer_user=roo
- definer_host=%
- suid=1
- with_check_option=0
- timestamp=2022-12-14 10:07:39
- create-version=1
- source=select `milksale`.`intPastureId` AS `intPastureId`,`milksale`.`dateOddDate` AS `dateOddDate`,sum(`milksale`.`decWeight`) AS `sale_wt` from `milksale` group by `milksale`.`intPastureId`,`milksale`.`dateOddDate`
- client_cs_name=utf8
- connection_cl_name=utf8_general_ci
- 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`
|
