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. -- Simcha Younger <sim...@syounger.com> -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/mysql?unsub=arch...@jab.org