| 12345678910111213141516 |
- TYPE=VIEW
- query=select `tmrwatch`.`downloadplandtl1`.`ID` AS `ID`,`tmrwatch`.`downloadplandtl1`.`FID` AS `FID`,`tmrwatch`.`downloadedplan`.`Mydate` AS `Mydate`,`tmrwatch`.`downloadedplan`.`TodayID` AS `TodayID`,`tmrwatch`.`downloadedplan`.`MobileMacNo` AS `MobileMacNo`,`tmrwatch`.`downloadedplan`.`DataCaptureNo` AS `DataCaptureNo`,`tmrwatch`.`downloadedplan`.`id` AS `planid`,`tmrwatch`.`downloadplandtl1`.`LastOpId` AS `LastOpId` from (`tmrwatch`.`downloadplandtl1` join `tmrwatch`.`downloadedplan` on(`tmrwatch`.`downloadplandtl1`.`PID` = `tmrwatch`.`downloadedplan`.`id`))
- md5=a1e7c1fbc3bf0ea719e66317f7c1b450
- updatable=1
- 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 `downloadplandtl1`.`ID` AS `ID`,`downloadplandtl1`.`FID` AS `FID`,`downloadedplan`.`Mydate` AS `Mydate`,`downloadedplan`.`TodayID` AS `TodayID`,`downloadedplan`.`MobileMacNo` AS `MobileMacNo`,`downloadedplan`.`DataCaptureNo` AS `DataCaptureNo`,`downloadedplan`.`id` AS `planid`,`downloadplandtl1`.`LastOpId` AS `LastOpId` from (`downloadplandtl1` join `downloadedplan` on((`downloadplandtl1`.`PID` = `downloadedplan`.`id`)))
- client_cs_name=utf8
- connection_cl_name=utf8_general_ci
- view_body_utf8=select `tmrwatch`.`downloadplandtl1`.`ID` AS `ID`,`tmrwatch`.`downloadplandtl1`.`FID` AS `FID`,`tmrwatch`.`downloadedplan`.`Mydate` AS `Mydate`,`tmrwatch`.`downloadedplan`.`TodayID` AS `TodayID`,`tmrwatch`.`downloadedplan`.`MobileMacNo` AS `MobileMacNo`,`tmrwatch`.`downloadedplan`.`DataCaptureNo` AS `DataCaptureNo`,`tmrwatch`.`downloadedplan`.`id` AS `planid`,`tmrwatch`.`downloadplandtl1`.`LastOpId` AS `LastOpId` from (`tmrwatch`.`downloadplandtl1` join `tmrwatch`.`downloadedplan` on(`tmrwatch`.`downloadplandtl1`.`PID` = `tmrwatch`.`downloadedplan`.`id`))
- mariadb-version=100511
|
