Sudantha Posted May 10, 2010 Share Posted May 10, 2010 Guys i need to run a Trigger in MySQL My code : $sql="INSERT into transactions values (NULL,'DIRECT DEBIT','".$acc."','2010/5/1','1.20PM',".$updated_res_acc_balance.",'0')"; DROP TRIGGER IF EXSITS CREATE TRIGGER updatesender AFTER INSERT ON transactions FOR EACH ROW UPDATE customers SET account_balance=".$updated_sender_acc_balance." WHERE username ='admin' "; this gives a error Link to comment https://forums.phpfreaks.com/topic/201275-trigger-e-in-mysql/ Share on other sites More sharing options...
Mchl Posted May 10, 2010 Share Posted May 10, 2010 Where are your delimiters? Link to comment https://forums.phpfreaks.com/topic/201275-trigger-e-in-mysql/#findComment-1055948 Share on other sites More sharing options...
Recommended Posts
Archived
This topic is now archived and is closed to further replies.