| 12345678910111213141516 |
- TYPE=VIEW
- query=(select `tmrwatch`.`newesttmrweighttime`.`DataCaptureNo` AS `DataCaptureNo`,`tmrwatch`.`newesttmrweighttime`.`MobileMacNo` AS `MobileMacNo`,max(`tmrwatch`.`newesttmrweighttime`.`recbuttonID`) AS `recbuttonID` from `tmrwatch`.`newesttmrweighttime` group by `tmrwatch`.`newesttmrweighttime`.`DataCaptureNo`)
- md5=90c672538ffd2601133896bad2d1a77d
- updatable=0
- algorithm=0
- definer_user=root
- definer_host=localhost
- suid=1
- with_check_option=0
- timestamp=2021-12-05 04:06:49
- create-version=2
- source=(select `newesttmrweighttime`.`DataCaptureNo` AS `DataCaptureNo`,`newesttmrweighttime`.`MobileMacNo` AS `MobileMacNo`,max(`newesttmrweighttime`.`recbuttonID`) AS `recbuttonID` from `newesttmrweighttime` group by `newesttmrweighttime`.`DataCaptureNo`)
- client_cs_name=utf8
- connection_cl_name=utf8_general_ci
- view_body_utf8=(select `tmrwatch`.`newesttmrweighttime`.`DataCaptureNo` AS `DataCaptureNo`,`tmrwatch`.`newesttmrweighttime`.`MobileMacNo` AS `MobileMacNo`,max(`tmrwatch`.`newesttmrweighttime`.`recbuttonID`) AS `recbuttonID` from `tmrwatch`.`newesttmrweighttime` group by `tmrwatch`.`newesttmrweighttime`.`DataCaptureNo`)
- mariadb-version=100511
|
