CREATE TABLE `pay` (
`Id` int(11) NOT NULL auto_increment,
`money` int(10) NOT NULL default '0',
`dateline` int(11) NOT NULL default '0',
PRIMARY KEY (`Id`)
) ENGINE=MyISAM AUTO_INCREMENT=8 DEFAULT CHARSET=utf-8;
INSERT INTO `pay` VALUES (1,100,1274588112);
INSERT INTO `pay` VALUES (2,5000,1274588112);
INSERT INTO `pay` VALUES (3,300,1274588018);
INSERT INTO `pay` VALUES (4,500,1274488112);
INSERT INTO `pay` VALUES (5,10,1274478151);
INSERT INTO `pay` VALUES (6,45,1274288112);
INSERT INTO `pay` VALUES (7,432,1274288502);
如表,dateline是timestamp现在要按天 对money 进行合计
求sql
from pay group by date(from_unixtime(dateline));
+------------+------------+
| date | sum(money) |
+------------+------------+
| 2010-05-20 | 477 |
| 2010-05-22 | 510 |
| 2010-05-23 | 5400 |
+------------+------------+