MySQL Forums
Forum List  »  Triggers

triggers not giving o/p in mysql QB
Posted by: ujvala ujvala
Date: October 22, 2005 12:53AM

hello everyone
triggers are not reflecting in mysql QB. i used the following statements. when i execute in mysql command line, then it is displaying the output. but mysql QB is returning null value. there is no error mesg. i have the mysql ver 5.0.12, and QB ver 1.1.15.

anyone plz help me!


"CREATE TABLE account (acct_num int(11) primary key, amount DECIMAL(10,2));

CREATE TRIGGER ins_sum BEFORE INSERT ON account
FOR EACH ROW SET @sum = @sum + NEW.amount;

SET @sum = 0;
INSERT INTO account VALUES(137,14.98),(141,1937.50),(97,-100.00);
SELECT @sum AS 'Total amount inserted';"


thanx all

UJVALA

Options: ReplyQuote


Subject
Views
Written By
Posted
triggers not giving o/p in mysql QB
2981
October 22, 2005 12:53AM


Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.