triggers not giving o/p in mysql QB
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
Subject
Views
Written By
Posted
triggers not giving o/p in mysql QB
2981
October 22, 2005 12:53AM
1836
October 22, 2005 01:20AM
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.