Using ASQL against a MySql database, I provide multiple sets of values in each INSERT statement. I am using the IGNORE clause to automatically drop duplicates. For example, if the combination of policy_id and endorsement_id is defined as UNIQUE:
mysql> INSERT IGNORE INTO production_tbl (policy_id,endorsement_id)
-> VALUES
-> ('14EA034E','00'),('14EA034E','00'),('14EA034E','00'),('14EA034E','01'),('14EA034E','02'),('14EA034E','03');
When invoked from the command line, MySQL returns a message like:
Query OK, 4 rows affected (0.01 sec)
Records: 6 Duplicates: 2 Warnings: 0
However, I am invoking these INSERTs from a program. I'd like to capture the number of Warnings and/or Duplicates resulting from each INSERT. Is there a way to do that with the standard SQL: functions?
-----
BTW: What happened to the "?" post icon?
Last edited by Steven Shatz; 07 Aug 19 08:43 PM.
