converting sqlserver trigger to mysql

[madhvee jain]

Hi,

I am new to both sql server and mysql and need to convert a sql server trigger to mysql. Here i am placing the sql server trigger. Can anyone help me to convert it to mysql?

Thanks in advance.

DROP TRIGGER [dbo].[RPT_WORKORDER_DETAIL_HISTORY_AI]
GO

--
-- Work_Order Table got inserted 1st, then followed by the Wo_Phase_Detail Table when new WO got created
--
CREATE TRIGGER RPT_WORKORDER_DETAIL_HISTORY_AI
ON WO_PHASE_DETAIL
AFTER INSERT
AS
INSERT RPT_WORKORDER_DETAIL_HISTORY
(FK_WORK_ORDER_NO, FK_SYSTEM_ID, FK_SITE_ID, FK_NODE_ID)
SELECT FK_WORK_ORDER_NO,
(select FK_SYSTEM_ID from WORK_ORDER where WORK_ORDER_NO = (select FK_WORK_ORDER_NO from inserted)),
(select FK_SITE_ID from WORK_ORDER where WORK_ORDER_NO = (select FK_WORK_ORDER_NO from inserted)),
(select FK_NODE_ID from WORK_ORDER where WORK_ORDER_NO = (select FK_WORK_ORDER_NO from inserted)),
(select WORK_ORDER_TYPE from WORK_ORDER where WORK_ORDER_NO = (select FK_WORK_ORDER_NO from inserted))

FROM inserted
GO