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
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
