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 Quote 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? Quote Link to comment https://forums.phpfreaks.com/topic/201275-trigger-e-in-mysql/#findComment-1055948 Share on other sites More sharing options...
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.