| 12345678910111213141516 |
- TYPE=VIEW
- query=select `newesttmrweighttime`.`downloadedplanid` AS `downloadedplanid`,`newesttmrweighttime`.`OperateName` AS `OperateName`,`newesttmrweighttime`.`OperateWeight` AS `OperateWeight`,if(`vbuttonactualweight`.`ActualWeight` is null,-1000,`vbuttonactualweight`.`ActualWeight`) AS `ActualWeight`,`newesttmrweighttime`.`InTime` AS `InTime` from (`tmrwatch`.`newesttmrweighttime` join `tmrwatch`.`vbuttonactualweight` on(`newesttmrweighttime`.`recbuttonID` = `vbuttonactualweight`.`id`))
- md5=e8a114ff29f677ee6efeaaa03258e391
- updatable=0
- algorithm=0
- definer_user=root
- definer_host=localhost
- suid=1
- with_check_option=0
- timestamp=2021-12-05 04:06:50
- create-version=2
- source=select `newesttmrweighttime`.`downloadedplanid` AS `downloadedplanid`,`newesttmrweighttime`.`OperateName` AS `OperateName`,`newesttmrweighttime`.`OperateWeight` AS `OperateWeight`,if(isnull(`vbuttonactualweight`.`ActualWeight`),-(1000),`vbuttonactualweight`.`ActualWeight`) AS `ActualWeight`,`newesttmrweighttime`.`InTime` AS `InTime` from (`newesttmrweighttime` join `vbuttonactualweight` on((`newesttmrweighttime`.`recbuttonID` = `vbuttonactualweight`.`id`)))
- client_cs_name=utf8
- connection_cl_name=utf8_general_ci
- view_body_utf8=select `newesttmrweighttime`.`downloadedplanid` AS `downloadedplanid`,`newesttmrweighttime`.`OperateName` AS `OperateName`,`newesttmrweighttime`.`OperateWeight` AS `OperateWeight`,if(`vbuttonactualweight`.`ActualWeight` is null,-1000,`vbuttonactualweight`.`ActualWeight`) AS `ActualWeight`,`newesttmrweighttime`.`InTime` AS `InTime` from (`tmrwatch`.`newesttmrweighttime` join `tmrwatch`.`vbuttonactualweight` on(`newesttmrweighttime`.`recbuttonID` = `vbuttonactualweight`.`id`))
- mariadb-version=100511
|
