how to convert sql trigger to mysql

[Omer Ahmed]

Dear all
i shifted from sql server to mysql . i wrote one trigger in sql server but now i m facing issues while converting it to mysql.
can anyone please help me

below is the trigger

USE [medicav1]
GO
/****** Object: Trigger [dbo].[COI_tri] Script Date: 7/15/2022 1:27:20 PM ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
ALTER TRIGGER [dbo].[COI_tri] ON [dbo].[COA]
FOR INSERT, UPDATE
AS
BEGIN
SET NOCOUNT ON
IF NOT EXISTS ( SELECT * FROM inserted)
RETURN
UPDATE dbo.COA
SET accounttype = CASE WHEN COA.openingbalance > 0 THEN 'DR'
ELSE 'CR' END
FROM dbo.COA COA
WHERE EXISTS ( SELECT *
FROM inserted i
WHERE i.coaid = COA.coaid
)
END