Select rows + Update selected (no replies)
(MySQL.com) Hello. I'm trouble with my algo:
I'm trying make changes to database 'on a fly' using such algo(C/C++):
SELECT rows from table
{
while (has new row)
{
UPDATE table SET field = value WHERE condition = #row_id;
}
}
My program doe
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:10:07
