Trigger

 You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'ON hi_renewal_license AFTER INSERT AS update hi_fee_payment set w_renewal='' at line 1


CREATE TRIGGER update_paym ON hi_renewal_license
AFTER INSERT AS
update hi_fee_payment
set w_renewal='PR'
from inserted
where hi_renewal_license.id_fee = inserted.id_fee