Hi List,
Any update on this
Thanks
Anil
Hi List,
Below is the output of mysqldumpslow. In the output query execution time is
showing -ve value how to interpret the below output i.e how to interpret
-ve value for query execution time please advice
Count: 1 Time=4294967223.00s (-73s) Lock=0.00s (0s) Rows=0.0 (0),
ebizb11[ebizb11]@
UPDATE MM_EMAIL,MM_GROUP SET MM_EMAIL.STATUS='S' WHERE
MM_EMAIL.EMAILADD=lower('S') AND MM_GROUP.ID=MM_EMAIL.GROUPID AND MM_GROUP
.DEPTID=N
Count: 1 Time=4294967223.00s (-73s) Lock=0.00s (0s) Rows=0.0 (0),
ebizb11[ebizb11]@
SELECT LIST.NAME,DEPT.NAME FROM MM_LIST LIST, MM_DEPARTMENT DEPT WHERE
LIST.DEPTID=DEPT.ID AND LIST.LISTTYPE = 'S' AND LIST.STATUS
= 'S' AND LIST.CREATEDDATE > DATE_SUB(NOW(),INTERVAL N DAY)
Thanks
Anil
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
