Page 1 of 1

Problem In Replace Query

Posted: Thu Aug 20, 2009 12:53 am
by habib009pk
Dear Friends

I have a little problem, i am working on a project, which is based on the updation of more than 1 lakh records after every 30 mins, In these records most of them are updated (80%) and some are inserted (20%).
Now I am using the REPLACE query which updated and inserted the records frequently. Now the problem is that as it has huge no of records I doesn't know that how many records are updated and how many are inserted.

Kindly Give me any idea that how can i know the no of records inserted and how many are updated through REPLACE query

Thanks And Regards

Re: Problem In Replace Query

Posted: Thu Aug 20, 2009 1:11 am
by VladSun
Maybe this will help you:
viewtopic.php?f=2&t=94003