I am trying to convert a MS SQL trigger to MySQL 5.6 (see trigger below). I am migrating an existing database over to MySQL. I am new to MySQL and the syntax is obviously a little different and I keep running into errors. I am under pressure to get this done which isn't helping. Could someone please look over the syntax and let me know if this is a minor fix or if the trigger needs to be re-written?
MS SQL Trigger:
CREATE TRIGGER order_details_total_cost ON order_details FOR INSERT,
SET GrandTotalCost = tots.total
) AS total
LEFT OUTER JOIN order_details ON insdel.fkOrderID = order_details.fkOrderID
OrderID = tots.fkOrderID