Jump to content

Trigger e in MySQL


Sudantha

Recommended Posts

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  :confused:

 

Link to comment
https://forums.phpfreaks.com/topic/201275-trigger-e-in-mysql/
Share on other sites

Archived

This topic is now archived and is closed to further replies.

×
×
  • Create New...

Important Information

We have placed cookies on your device to help make this website better. You can adjust your cookie settings, otherwise we'll assume you're okay to continue.