MySQL Forums
Forum List  »  Oracle

Turn INSERT INTO query into UPDATE
Posted by: Jack Hard
Date: March 10, 2013 08:56PM

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?

Options: ReplyQuote

Written By
Turn INSERT INTO query into UPDATE
March 10, 2013 08:56PM

Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.