Stored Proc & Time Intervals (2 replies)
(MySQL.com) I've checked all over this forum, but I don't see an answer to what I'm looking for --
I have a mySql Db (5.0.51a-3ubuntu5.4) with a small database. I have written a stored procedure that checks all the records in a small table and updates them 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:11