Re: how to convert sql trigger to mysql
> 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.
Subject
Views
Written By
Posted
903
July 15, 2022 03:25AM
343
July 15, 2022 06:35AM
335
July 15, 2022 03:40PM
Re: how to convert sql trigger to mysql
402
July 15, 2022 08:44PM
321
July 15, 2022 10:22PM
430
July 16, 2022 07:23AM
Sorry, you can't reply to this topic. It has been closed.
This forum is currently read only. You can not log in or make any changes. This is a temporary situation.
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.