MySQL Forums
Forum List  »  Triggers

Re: Trigger
Posted by: Ronan Cashell
Date: April 28, 2011 02:14AM

You mention IF new.community = 'public' then ... but above you say it should be "Public". Databases are case sensitive. Make sure you community field is populated with the word 'public' in lowercase to make it work.

Ronan Cashell
Senior Oracle/MySQL Administrator
IT Integrated Business Solutions
http://www.it-iss.com

Options: ReplyQuote


Subject
Views
Written By
Posted
2536
April 27, 2011 08:06AM
915
April 27, 2011 09:35AM
1047
April 28, 2011 06:46AM
875
May 03, 2011 04:12AM
Re: Trigger
885
April 28, 2011 02:14AM


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.