Simcha Younger wrote:
On Mon, 04 Oct 2010 16:11:08 -0400
kalin m <ka...@el.net> wrote:
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?
The two values you have here are equal:
sample data : 12862162510269684
query: where unix_time < 12862162510269684
and therefore the 'less than' query did not match that row.
sorry... not following.... the value in the table was
12862162385941345. the time in the query was 12862162510269684.
mysql> select 12862162385941345 < 12862162510269684;
+---------------------------------------+
| 12862162385941345 < 12862162510269684 |
+---------------------------------------+
| 1 |
+---------------------------------------+
1 row in set (0.00 sec)
