0

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

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
2
Contributors
2
Replies
3
Views
9 Years
Discussion Span
Last Post by veledrom
0

I tried but didn't work. I dont use this logic. Therefore, ignore this post.
Thanks for your reply tejusi/

This question has already been answered. Start a new discussion instead.
Have something to contribute to this discussion? Please be thoughtful, detailed and courteous, and be sure to adhere to our posting rules.