Problem In Replace Query

Questions about the MySQL, PostgreSQL, and most other databases, as well as using it with PHP can be asked here.

Moderator: General Moderators

Post Reply
habib009pk
Forum Commoner
Posts: 43
Joined: Sun Jul 05, 2009 11:28 pm

Problem In Replace Query

Post 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
User avatar
VladSun
DevNet Master
Posts: 4313
Joined: Wed Jun 27, 2007 9:44 am
Location: Sofia, Bulgaria

Re: Problem In Replace Query

Post by VladSun »

Maybe this will help you:
viewtopic.php?f=2&t=94003
There are 10 types of people in this world, those who understand binary and those who don't
Post Reply