MySQL Forums
Forum List  »  Triggers

Re: Syntax error in trigger
Posted by: Peter Brawley
Date: August 13, 2017 11:09AM

Unmatched left paren before exists(SELECT...). Use a text editor that sees such errors, eg NotePad++ or TextPad.

And BTW, if exists(SELECT 1 ...) would be more efficient than selecting *.

> here I'm hoping post_id is the post_id related to the new inserted row
> I don't know if this is wrong

If you're hoping, it's wrong, ie if you're not sure, you need to verify it.

Options: ReplyQuote


Subject
Views
Written By
Posted
1727
August 11, 2017 03:37AM
646
August 11, 2017 10:57AM
838
August 12, 2017 02:47AM
641
August 12, 2017 07:49AM
776
August 13, 2017 12:15AM
848
August 13, 2017 12:35AM
Re: Syntax error in trigger
788
August 13, 2017 11:09AM
696
August 14, 2017 05:47AM
708
August 14, 2017 10:17AM


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.