12345678910111213141516 |
- TYPE=VIEW
- 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`
- md5=568436639d69229b25c815f83d346c21
- 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 `recweight`.`SrcAddr` AS `SrcAddr`,timestampdiff(MINUTE,max(`recweight`.`MTime`),now()) AS `NewestTime` from `recweight` where (`recweight`.`SrcAddr` is not null) group by `recweight`.`SrcAddr`
- client_cs_name=utf8
- connection_cl_name=utf8_general_ci
- 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`
- mariadb-version=100511
|