Hi Lists,
I have created a procedure to calculate and update a statistics. It works correctly. It
updates daily. For a single day alone it shows records in reverse order. For other days
it shows correctly. Will this happen? but the date with time shows the orders in revers
check the order for "2008-02-22"
mysql> select * from stats;
| 2008-02-21 | 0 | 0 | 2008-02-21 01:25:01 |
| 2008-02-21 | 1 | 58 | 2008-02-21 01:25:02 |
| 2008-02-21 | 5 | 0 | 2008-02-21 01:25:02 |
| 2008-02-21 | 10 | 523 | 2008-02-21 01:25:14 |
| 2008-02-21 | 20 | 1 | 2008-02-21 01:25:14 |
| 2008-02-21 | 21 | 3 | 2008-02-21 01:25:14 |
| 2008-02-21 | 22 | 0 | 2008-02-21 01:25:14 |
| 2008-02-21 | 23 | 0 | 2008-02-21 01:25:14 |
| 2008-02-21 | 24 | 0 | 2008-02-21 01:25:15 |
| 2008-02-21 | 40 | 0 | 2008-02-21 01:25:15 |
| 2008-02-21 | 50 | 4 | 2008-02-21 01:25:16 |
| 2008-02-21 | 51 | 0 | 2008-02-21 01:25:16 |
| 2008-02-21 | 52 | 27 | 2008-02-21 01:25:17 |
| 2008-02-21 | 53 | 0 | 2008-02-21 01:25:17 |
| 2008-02-21 | 54 | 0 | 2008-02-21 01:25:17 |
| 2008-02-21 | 60 | 0 | 2008-02-21 01:25:17 |
| 2008-02-21 | 70 | 0 | 2008-02-21 01:25:17 |
| 2008-02-21 | 90 | 0 | 2008-02-21 01:25:17 |
| 2008-02-21 | 100 | 0 | 2008-02-21 01:25:17 |
| 2008-02-22 | 100 | 0 | 2008-02-22 18:12:00 |
| 2008-02-22 | 90 | 0 | 2008-02-22 18:12:00 |
| 2008-02-22 | 70 | 0 | 2008-02-22 18:12:00 |
| 2008-02-22 | 60 | 0 | 2008-02-22 18:11:59 |
| 2008-02-22 | 54 | 0 | 2008-02-22 18:11:59 |
| 2008-02-22 | 53 | 0 | 2008-02-22 18:11:59 |
| 2008-02-22 | 52 | 0 | 2008-02-22 18:11:59 |
| 2008-02-22 | 51 | 0 | 2008-02-22 18:11:58 |
| 2008-02-22 | 50 | 0 | 2008-02-22 18:11:58 |
| 2008-02-22 | 40 | 0 | 2008-02-22 18:11:58 |
| 2008-02-22 | 24 | 0 | 2008-02-22 18:11:58 |
| 2008-02-22 | 23 | 0 | 2008-02-22 18:11:56 |
| 2008-02-22 | 22 | 0 | 2008-02-22 18:11:56 |
| 2008-02-22 | 21 | 0 | 2008-02-22 18:11:56 |
| 2008-02-22 | 20 | 0 | 2008-02-22 18:11:56 |
| 2008-02-22 | 10 | 0 | 2008-02-22 18:11:56 |
| 2008-02-22 | 5 | 0 | 2008-02-22 18:11:24 |
| 2008-02-22 | 1 | 0 | 2008-02-22 18:11:24 |
| 2008-02-22 | 0 | 0 | 2008-02-22 18:11:24 |
| 2008-02-23 | 0 | 0 | 2008-02-23 18:10:59 |
| 2008-02-23 | 1 | 0 | 2008-02-23 18:11:00 |
| 2008-02-23 | 5 | 0 | 2008-02-23 18:11:00 |
| 2008-02-23 | 10 | 0 | 2008-02-23 18:11:07 |
| 2008-02-23 | 20 | 0 | 2008-02-23 18:11:07 |
| 2008-02-23 | 21 | 0 | 2008-02-23 18:11:08 |
| 2008-02-23 | 22 | 0 | 2008-02-23 18:11:08 |
| 2008-02-23 | 23 | 0 | 2008-02-23 18:11:08 |
| 2008-02-23 | 24 | 0 | 2008-02-23 18:11:23 |
| 2008-02-23 | 40 | 0 | 2008-02-23 18:11:23 |
| 2008-02-23 | 50 | 0 | 2008-02-23 18:11:23 |
| 2008-02-23 | 51 | 0 | 2008-02-23 18:11:23 |
| 2008-02-23 | 52 | 0 | 2008-02-23 18:11:24 |
| 2008-02-23 | 53 | 0 | 2008-02-23 18:11:24 |
| 2008-02-23 | 54 | 0 | 2008-02-23 18:11:24 |
| 2008-02-23 | 60 | 0 | 2008-02-23 18:11:24 |
| 2008-02-23 | 70 | 0 | 2008-02-23 18:11:24 |
| 2008-02-23 | 90 | 0 | 2008-02-23 18:11:24 |
| 2008-02-23 | 100 | 0 | 2008-02-23 18:11:24 |
| 2008-02-24 | 0 | 0 | 2008-02-24 18:10:35 |
| 2008-02-24 | 1 | 0 | 2008-02-24 18:10:36 |
| 2008-02-24 | 5 | 0 | 2008-02-24 18:10:36 |
| 2008-02-24 | 10 | 0 | 2008-02-24 18:10:42 |
| 2008-02-24 | 20 | 0 | 2008-02-24 18:10:42 |
| 2008-02-24 | 21 | 0 | 2008-02-24 18:10:42 |
| 2008-02-24 | 22 | 0 | 2008-02-24 18:10:43 |
| 2008-02-24 | 23 | 0 | 2008-02-24 18:10:43 |
| 2008-02-24 | 24 | 0 | 2008-02-24 18:10:53 |
| 2008-02-24 | 40 | 0 | 2008-02-24 18:10:53 |
| 2008-02-24 | 50 | 0 | 2008-02-24 18:10:53 |
| 2008-02-24 | 51 | 0 | 2008-02-24 18:10:53 |
| 2008-02-24 | 52 | 0 | 2008-02-24 18:10:54 |
| 2008-02-24 | 53 | 0 | 2008-02-24 18:10:54 |
| 2008-02-24 | 54 | 0 | 2008-02-24 18:10:54 |
| 2008-02-24 | 60 | 0 | 2008-02-24 18:10:54 |
| 2008-02-24 | 70 | 0 | 2008-02-24 18:10:54 |
| 2008-02-24 | 90 | 0 | 2008-02-24 18:10:54 |
| 2008-02-24 | 100 | 0 | 2008-02-24 18:10:54 |
Saravanan
____________________________________________________________________________________
Never miss a thing. Make Yahoo your home page.
http://www.yahoo.com/r/hs
