我在mysql里面执行这个sql语句总是当机,高手来救命啊~
SELECT b.AccountId,d.Description,d.Meaning,c.LevelCode,c.Value FROM PrismaLog a INNER JOIN PrismaLog b ON a.AccountId=b.AccountId AND ON a.Date=b.Date AND ON a.ServerId=b.ServerId INNER JOIN LogValue c ON b.LogId=c.LogId INNER JOIN LogMap d ON c.LevelCode=d.LevelCode WHERE a.ServerId='sip13379' AND (TO_DAYS(a.Date)-TO_DAYS('2007-7-1')>= 0) AND (TO_DAYS(a.Date)-TO_DAYS('2007-7-13') <= 0) AND a.RecordId='1040' AND b.RecordId='1030.0' AND d.RecordId='1030' SELECT b.A
SELECT b.AccountId,d.Description,d.Meaning,c.LevelCode,c.Value FROM PrismaLog a INNER JOIN PrismaLog b ON a.AccountId=b.AccountId AND ON a.Date=b.Date AND ON a.ServerId=b.ServerId INNER JOIN LogValue c ON b.LogId=c.LogId INNER JOIN LogMap d ON c.LevelCode=d.LevelCode WHERE a.ServerId='sip13379' AND (TO_DAYS(a.Date)-TO_DAYS('2007-7-1')>= 0) AND (TO_DAYS(a.Date)-TO_DAYS('2007-7-13') <= 0) AND a.RecordId='1040' AND b.RecordId='1030.0' AND d.RecordId='1030' SELECT b.A