Can somebody please help!
There are two queries -
1. How can I detect from my code whether a table has been updated in the Database manually
(I am firing delete from testtable where SrNo>=9; on the Database server) and not from
the code itself. I am running this code -
conn = mysql_init(NULL);
/* Connect to database */
if (!mysql_real_connect(conn, server, user, password, database, 0, NULL, 0)) {
fprintf(stderr, "%s\n", mysql_error(conn));
exit(1);
}
my_ulonglong affect_fields;
while(1)
{
affect_fields = mysql_affected_rows(conn);
if ((long) affect_fields >=1)
{
printf("%ld products updated\n\n", (long)
affect_fields);
}
}
2. And if the table is really updated/inserted/deleted for any record then how to check
which that record was.
Regards,
Gaurav.
