tmrwithweighttime.frm 983 B

12345678910111213141516
  1. TYPE=VIEW
  2. query=select `tmrwatch`.`tmr`.`ID` AS `ID`,`tmrwatch`.`tmr`.`TNAME` AS `TNAME`,`newestweighttime`.`NewestTime` AS `NewestTime` from (`tmrwatch`.`tmr` join `tmrwatch`.`newestweighttime` on(`tmrwatch`.`tmr`.`DataCaptureNo` = `newestweighttime`.`SrcAddr`))
  3. md5=a46ea4f5a0cdcad1cea6408767771057
  4. updatable=0
  5. algorithm=0
  6. definer_user=root
  7. definer_host=localhost
  8. suid=1
  9. with_check_option=0
  10. timestamp=2021-12-05 04:06:49
  11. create-version=2
  12. source=select `tmr`.`ID` AS `ID`,`tmr`.`TNAME` AS `TNAME`,`newestweighttime`.`NewestTime` AS `NewestTime` from (`tmr` join `newestweighttime` on((`tmr`.`DataCaptureNo` = `newestweighttime`.`SrcAddr`)))
  13. client_cs_name=utf8
  14. connection_cl_name=utf8_general_ci
  15. view_body_utf8=select `tmrwatch`.`tmr`.`ID` AS `ID`,`tmrwatch`.`tmr`.`TNAME` AS `TNAME`,`newestweighttime`.`NewestTime` AS `NewestTime` from (`tmrwatch`.`tmr` join `tmrwatch`.`newestweighttime` on(`tmrwatch`.`tmr`.`DataCaptureNo` = `newestweighttime`.`SrcAddr`))
  16. mariadb-version=100511