newestweighttime.frm 1.0 KB

12345678910111213141516
  1. TYPE=VIEW
  2. query=select `tmrwatch`.`recweight`.`SrcAddr` AS `SrcAddr`,timestampdiff(MINUTE,max(`tmrwatch`.`recweight`.`MTime`),current_timestamp()) AS `NewestTime` from `tmrwatch`.`recweight` where `tmrwatch`.`recweight`.`SrcAddr` is not null group by `tmrwatch`.`recweight`.`SrcAddr`
  3. md5=568436639d69229b25c815f83d346c21
  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 `recweight`.`SrcAddr` AS `SrcAddr`,timestampdiff(MINUTE,max(`recweight`.`MTime`),now()) AS `NewestTime` from `recweight` where (`recweight`.`SrcAddr` is not null) group by `recweight`.`SrcAddr`
  13. client_cs_name=utf8
  14. connection_cl_name=utf8_general_ci
  15. view_body_utf8=select `tmrwatch`.`recweight`.`SrcAddr` AS `SrcAddr`,timestampdiff(MINUTE,max(`tmrwatch`.`recweight`.`MTime`),current_timestamp()) AS `NewestTime` from `tmrwatch`.`recweight` where `tmrwatch`.`recweight`.`SrcAddr` is not null group by `tmrwatch`.`recweight`.`SrcAddr`
  16. mariadb-version=100511