I have a piece of software that runs an INSERT INTO query in my MySQL database. I'd like this software to update a row in the table it is accessing instead of creating a new row. I have no access to change the query in the software, so I'm wondering if there is some way to make this happen by other means. Is there a setting I can change on my table, or can I create a new view that the software can use that will make this work? Is this even possible? I have a piece of software that runs an INSERT