MySQL Forums
Forum List  »  Other Migration

Re: how to convert sql trigger to mysql
Posted by: Peter Brawley
Date: July 15, 2022 08:44PM

> your converted trigger not working

It's not my converted Trigger. If I were to write it for you, I'd need the complete DDL for the tables involved.

But I'm not trying to write it for you. That's your job. Instead, given incomplete information, I'm suggesting how to write it and offering an example of how such a Trigger would probably look.

> this trigger is not working on existing values(data) of chart of account.

MySQL Triggers are fired only by Insert, Update and Delete commands. If you're trying to modify existing values only, why not just write an Update query?

Edited 1 time(s). Last edit at 07/15/2022 09:54PM by Peter Brawley.

Options: ReplyQuote

Written By
Re: how to convert sql trigger to mysql
July 15, 2022 08:44PM

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.