v_ref_dtl1_succ.frm 1.7 KB

12345678910111213141516
  1. TYPE=VIEW
  2. query=select `tmrwatch`.`downloadplandtl1`.`ID` AS `ID`,`tmrwatch`.`downloadplandtl1`.`PID` AS `PID`,`tmrwatch`.`downloadplandtl1`.`FID` AS `FBarID`,`tmrwatch`.`downloadplandtl1`.`LWEIGHT` AS `LWEIGHT`,`tmrwatch`.`downloadplandtl1`.`ActualWeight` AS `ActualWEIGHT`,`tmrwatch`.`downloadplandtl1`.`ErrRatio` AS `ErrRatio`,`tmrwatch`.`downloadplandtl1`.`ActualWeightMinus` AS `ActualWeightMinus` from `tmrwatch`.`downloadplandtl1` where `tmrwatch`.`downloadplandtl1`.`ButtonSucc` = 1 and `tmrwatch`.`downloadplandtl1`.`FID` is not null
  3. md5=12a55dd700f3d7135639621826bc2abc
  4. updatable=1
  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 `downloadplandtl1`.`ID` AS `ID`,`downloadplandtl1`.`PID` AS `PID`,`downloadplandtl1`.`FID` AS `FBarID`,`downloadplandtl1`.`LWEIGHT` AS `LWEIGHT`,`downloadplandtl1`.`ActualWeight` AS `ActualWEIGHT`,`downloadplandtl1`.`ErrRatio` AS `ErrRatio`,`downloadplandtl1`.`ActualWeightMinus` AS `ActualWeightMinus` from `downloadplandtl1` where ((`downloadplandtl1`.`ButtonSucc` = 1) and (`downloadplandtl1`.`FID` is not null))
  13. client_cs_name=utf8
  14. connection_cl_name=utf8_general_ci
  15. view_body_utf8=select `tmrwatch`.`downloadplandtl1`.`ID` AS `ID`,`tmrwatch`.`downloadplandtl1`.`PID` AS `PID`,`tmrwatch`.`downloadplandtl1`.`FID` AS `FBarID`,`tmrwatch`.`downloadplandtl1`.`LWEIGHT` AS `LWEIGHT`,`tmrwatch`.`downloadplandtl1`.`ActualWeight` AS `ActualWEIGHT`,`tmrwatch`.`downloadplandtl1`.`ErrRatio` AS `ErrRatio`,`tmrwatch`.`downloadplandtl1`.`ActualWeightMinus` AS `ActualWeightMinus` from `tmrwatch`.`downloadplandtl1` where `tmrwatch`.`downloadplandtl1`.`ButtonSucc` = 1 and `tmrwatch`.`downloadplandtl1`.`FID` is not null
  16. mariadb-version=100511