MySQL

Mysql Trigger error

Please support our MySQL advertiser: PostgreSQL or MySQL? Compare and contrast the two most popular open source databases

Thread Solved

•

Join Date: Apr 2008

Posts: 490

Reputation: veledrom is an unknown quantity at this point

Solved Threads: 0

veledrom

Offline

Posting Pro in Training

Mysql Trigger error

Jul 25th, 2008

Hi,

Select closing From balance Where account_no = 12 Limit 1 returns an error "You can't specify target table 'balance' for update in FROM clause"
Where is mistake?
Thanks

 Help with Code Tags 
 MySQL Syntax (Toggle Plain Text) 
AFTER INSERT ON Close
BEGIN
INSERT INTO balance (DATE, opening, account) 
VALUES (CURDATE(), (SELECT closing FROM balance WHERE account_no = 12 LIMIT 1), 12);
END
AFTER INSERT ON Close
BEGIN
Insert into balance (date, opening, account) 
Values (CURDATE(), (Select closing From balance Where account_no = 12 Limit 1), 12);
END

Last edited by veledrom; Jul 25th, 2008 at 6:11 am. Reason: mistake

•

Join Date: Apr 2008

Posts: 296

Reputation: tesuji is on a distinguished road

Solved Threads: 42

tesuji

Offline

Posting Whiz in Training

Re: Mysql Trigger error

Jul 25th, 2008

Hello

Your mistake! You cannot do that !

-----
tesu

Information is moving—you know, nightly news is one way, of course, but it's also moving through the blogosphere and through the Internets. I promise you I will listen to what has been said here, even though I wasn't here. Ann and I will carry out this equivocal message to the world. I'm the master of low expectations.