Mysql Sum and Group By Method

问题:

Input

Date            Points            Email

2012-07-01       5                 [e-mail]
2012-07-01       6                [e-mail]
2012-07-01       2                 [e-mail]

2012-07-02       5                [e-mail]

2012-07-03       8                [e-mail]
2012-07-03       7                 [e-mail]
2012-07-03       1                 [e-mail]

2012-07-04       3                [e-mail]
2012-07-04       2                [e-mail]

2012-07-05       3                [e-mail]
2012-07-05       9                [e-mail]

Output

Date            Points

2012-07-01       13
2012-07-02        5
2012-07-03       16
2012-07-04        5
2012-07-05       12

Suggest me an MySQL Query for output like the above

回答1:

try

 SELECT `date`, SUM(`Points`) AS sumPoint FROM table GROUP BY `date`

Note : dont forget to wrap date column with ` as DATE is reserve keyword of mySQL

回答2:

SELECT date, SUM(Points) AS sumPoint FROM table GROUP BY DATE(date)

Since date column might be datetime or date type in table