Getting number of rows inserted for ON DUPLICATE KEY UPDATE multiple insert?

by

The number of inserts would be 2000 minus the number of affected rows. More generally:

(numberOfValuesInInsert * 2) - mysql_affected_rows()

EDIT:

As tomas points out, The MySQL docs actually say:

With ON DUPLICATE KEY UPDATE, the affected-rows value per row is 1 if the row is inserted as a new row, 2 if an existing row is updated, and 0 if an existing row is set to its current values.

[emphasis mine]

Consequently, if setting an existing row to the same values is a possibility, it’s impossible to tell how many rows were updated vs. inserted, since two inserts would be indistinguishable from one update with different values + one update with the same values.

More Related Contents:

  1. Error related to only_full_group_by when executing a query in MySql
  2. Find duplicate records in MySQL
  3. How to declare a variable in MySQL?
  4. Can you split/explode a field in a MySQL query?
  5. MySQL order by before group by
  6. MySQL Cannot Add Foreign Key Constraint
  7. Which is fastest? SELECT SQL_CALC_FOUND_ROWS FROM `table`, or SELECT COUNT(*)
  8. Grouping into interval of 5 minutes within a time range
  9. ERROR 1044 (42000): Access denied for user ”@’localhost’ to database ‘db’
  10. Difference between float and decimal data type
  11. Parse date in MySQL
  12. mysql dynamic query in stored procedure
  13. Table is ‘read only’
  14. How to select one row randomly taking into account a weight?
  15. auto_increment by group
  16. Table is specified twice, both as a target for ‘UPDATE’ and as a separate source for data in mysql
  17. MySQL export into outfile : CSV escaping chars
  18. Simple Random Samples from a MySQL Sql database
  19. MySQL LAST_INSERT_ID() used with multiple records INSERT statement
  20. MySQL Select minimum/maximum among two (or more) given values
  21. MySQL: Many tables or many databases?
  22. Select only last value using group by at mysql
  23. AWS Aurora MySQL serverless: how to connect from MySQL Workbench
  24. DELETE FROM `table` AS `alias` … WHERE `alias`.`column` … why syntax error?
  25. Incorrect key file for table ‘/tmp/#sql_3c51_0.MYI’; try to repair it [duplicate]
  26. How to store data with dynamic number of attributes in a database
  27. MySQL Auto increment primary key increases by 10
  28. Escape line breaks in MySQL output
  29. MySQL Relationships
  30. Laravel – search with multiple keywords against multiple columns with the search result to be ordered in relevance

Leave a Comment