mysql> select left(from_unixtime(create_day),10), count(*) cnt, sum(view) view from guild_board9 where create_day >= unix_timestamp('2008-02-04') group by 1 ;
+------------------------------------+-----+------+
| left(from_unixtime(create_day),10) | cnt | view |
+------------------------------------+-----+------+
| 2008-02-04 | 57 | 268 |
+------------------------------------+-----+------+
1 row in set (0.00 sec)
mysql> select left(from_unixtime(create_day),10), count(*) cnt, sum(view) view from guild_board9 where create_day = unix_timestamp('2008-02-04') group by 1 ;
Empty set (0.00 sec)
어찌하여 위와 같은 결과가 나오는지요?? |