List:General Discussion« Previous MessageNext Message »
From:Saravanan Date:February 25 2008 4:21pm
Subject:records ordered incorrectly
View as plain text  
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
Thread
records ordered incorrectlySaravanan25 Feb
  • Re: records ordered incorrectlyDan Nelson25 Feb