c - How to get mysql to throw an error on update for no rows matched? -

i want know when update query reports 0 rows matches. i'm using libmysql.

here's code i'm using:

char query[300] = {0}; snprintf(query, 300, "update `my_table` set name='%s' id=%d",          name, id);  if (mysql_query(db, query)) {     printf("error!\n"); } 

essentially need know whether or not there match id. know can check doing select, there way?

check mysql_affected_rows. return number of modified rows last query.

however, may return rows modified. if want return matched row, have specify client_found_rows in mysql_real_connect. check same page details.