When my DB insert into MySQL is denied due to a unique field that is already populated, I want to update the field called "counter" for that record so I know how many times a duplicate record tried to perform the insert.
I know that MySQL has something called ON DUPLICATE KEY but I was hoping that there might already be something similar in Rails?
If not, I was thinking I would have to do something like:
- unless @record.save - find the ID of the duplicate record - add one to the value of the counter field for that record
Any ideas would be received warmly
jackster