Web lists-archives.com

Query Statistics...




Hi All,

Perhaps a bit of a trivial question, but in terms of query statistics (i.e.
how many SELECT / INSERT / DELETE / etc. queries has been ran against the
server)...

When you take an INSERT ... ON DUPLICATE KEY UPDATE ...

Under the two conditions (i.e. either INSERT, or UPDATE if the record
already exist),  how is this query logged in the statistics?

When the ON DUPLICATE KEY UPDATE runs (i.e. it's updating a record), is it
still logged as a INSERT query, or is it logged as a UPDATE query?

Thnx.



-- 

Regards,
Chris Knipe