2009-12-26 2:36, Don Read :
Change noticed to enum('new', 'scan', 'done') not null default 'new';
When proc two runs, it should
"UPDATE noticed='scan' WHERE noticed='new'"
Then repeat the scan with "SELECT ... WHERE noticed='scan'"
...
and finally it should "UPDATE domain=whatever, ... noticed='done'"
Thanks Don.
That means, when process one want to update "ip" but it see
noticed="scan", it will block until the status become "done", is it?
Eva
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/mysql?unsub=arch...@jab.org
