hi all...
i'm doing tests with a table that gets updated based on random unix
times it contains. there is a column that has a bunch or random times
that look like:
+---------------------+-------------------+
| date_time | unix_time |
+---------------------+-------------------+
| 2010-10-01 10:24:52 | 12859430921341418 |
| 2010-10-01 21:18:13 | 12859822937839442 |
| 2010-10-01 16:08:00 | 12859636809115039 |
| 2010-10-01 19:47:43 | 12859768633824661 |
| 2010-10-01 16:48:30 | 12859661104829142 |
| 2010-10-01 15:25:37 | 12859611374324533 |
| 2010-10-01 12:27:28 | 12859504483288358 |
+---------------------+-------------------+
what i'm trying to do is update the column only of one of those times
isn't yet passed. and it works. except sometimes...
like these 2 unix times:
this was in the table under unix time: 12862162385941345...
this 12862162510269684 got passed in the update command as in:
update the_table set updated = 1 where unix_time < 12862162510269684
limit 1;
executing this query didn't update the record.
why?
thanks...
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/mysql?unsub=arch...@jab.org