SELECT SUM(bmw.field1) AS `field1`,SUM(bmw.field2 + bmw.field3) AS `field23`,(SELECT SUM(t1.field1) FROM bmw_order t1 WHERE t1.`status` = 0) AS `field1_all`
FROM bmw_order bmw
WHERE bmw.create_time < 1359475200 AND bmw.`status` = 0;
FROM bmw_order bmw
WHERE bmw.create_time < 1359475200 AND bmw.`status` = 0;
`status`有多少种值
status 目前只有两种种值,后面可能会有10种左右
时间字段where不限于小于当天:)
FROM bmw_order bmw ,(SELECT SUM(t1.field1) as `field1_all` FROM bmw_order t1 WHERE t1.`status` = 0) b
WHERE bmw.create_time < 1359475200 AND bmw.`status` = 0;create index xxxx on bmw_order (status,create_time )