How do I guarantee uniqueness in a concurrent scenario? (1 reply)
(MySQL.com) Hi
I have some fairly simple requirements but I'm not sure how I implement them:
- I have multiple concurrent threads running the same query
- The query supplies a 'name' value - if it exists in the Name table, the query should return the i
Update update feed set failed_fetches=0, fetched=current_timestamp() where feed_id = 1268 failed: 1142 [UPDATE command denied to user '334187_hdlns_ms5'@'10.187.248.89' for table 'feed'] in [update feed set failed_fetches=0, fetched=current_timestamp() where feed_id = 1268]
updated 1268 (MySQL User Forums), inserted 30, updated 0, at 2012-06-02 00:12:49
