SELECT sum( soccess ) AS result
FROM record
WHERE username
IN (SELECT username
FROM member
WHERE parent
IN (SELECT username
FROM manager
WHERE parent = 'test'
)
)
AND datetime >= '2007-01-27 00:00:00'
AND datetime <= '2007-01-27 23:59:59'
难道是语句太复杂了?
JAVA中是用连接池的。
FROM record
WHERE username
IN (SELECT username
FROM member
WHERE parent
IN (SELECT username
FROM manager
WHERE parent = 'test'
)
)
AND datetime >= '2007-01-27 00:00:00'
AND datetime <= '2007-01-27 23:59:59'
难道是语句太复杂了?
JAVA中是用连接池的。
我在局域网的windows装了一个standard版,查询却很快。
自己机上是max版的,rpm安装。
问一下大家max和standard版有什么区别?