Partial fetched SELECT statement result and UPDATE

[Andrey Sevchenko]

Hi!
I'm had two mysql connections. Using first I'm select some data:
SELECT time, value FROM `my_table` WHERE time <= 1268409464 AND time >= 0 ORDER BY time LIMIT 86400

Using second connection I'm trying to change given row value like
UPDATE `my_table` SET value=1.1 WHERE time=919462145

e.g. I'm want to implement such algo:
while (has rows) { fetch_row(connection #1); change_row(connection #2, value); }

Using MyISAM my program simply stop fetching data and exit silently. Changing MyISAM Engine to InnoDB cause "The total number of locks exceeds the lock tables"

---
Program language: C [gcc version 4.4.3 20100108]
MySQL: Ver 14.14 Distrib 5.1.41, for debian-linux-gnu (i486) using readline 6.1