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
750
July 15, 2022 03:25AM
288
July 15, 2022 06:35AM
281
July 15, 2022 03:40PM
Re: how to convert sql trigger to mysql
333
July 15, 2022 08:44PM
260
July 15, 2022 10:22PM
352
July 16, 2022 07:23AM
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.