Getting mysql "UNaffected" rows
 

Hi,

My php script would do a few updates/inserts to a table. after that I would like the rows that have not been affected by the script to be deleted from the database.

cant figure out how to do this.

any ideas ?

Re: Getting mysql "UNaffected" rows
 

Well if you are using a condition to select the rows to be inserted/updated just reverse the condition and do a delete on those so if you have something like WHERE name = "bob" just do WHERE name != "bob" aside from reversing a condition I'm not sure there is a way of getting the unaffected rows (hopefully I will be corrected on this)