MySQL Forums
Forum List  »  Connector/ODBC

Re: Filtering / modify incoming SQL instruction ?
Posted by: Peter Brawley
Date: January 21, 2019 05:01PM

I think the name for that is "hacking", and one hopes it's intimidatingly hard to do.

Supposing all this is legitimate, one way is to redirect the command to another table by creating a database named dbname, in it create a table named res_partner with the desired columns, and on that db.table create a before-update trigger that updates the target table in the desired database.

Options: ReplyQuote

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.