Creating Triggers

2006-06-21 Thread Palani kodeswaran
I am trying to create a trigger which will eventually call a judf.. However my mysql does not understand the delimiter command. actually... help doesnot even list delimiter as a possible command.. I am using MySQL- 5.0-22 Max server ... Installed it from a non-rpm binary distribution.. Also.. is i

creating triggers?

2005-12-30 Thread Brittingham, John
I would like to create a trigger that either updates or inserts a row in my USERS_PER_HOUR table when an entry is made in the LOG table. The log table has LOG_DATE, LOG_TIME and a CUID columns that I would like to either create a new row if the LOG_DATE and LOG_TIME do not exist or update the num

Re: Creating Triggers and procedures in MySQL

2003-10-05 Thread Gregory Hicks
>"I love stored-procedures" and the "I hate store-procedure" groups of >people. Hopefully, we won't get that again. If you are interested in >the lengthy discussion, you may want to search the list archives. > >On Mon, 06 Oct 2003 10:54:48 -0850 (CDT), Gregory

Re: Creating Triggers and procedures in MySQL

2003-10-05 Thread Jeff Shapiro
ou may want to search the list archives. On Mon, 06 Oct 2003 10:54:48 -0850 (CDT), Gregory Hicks spoke thusly about Creating Triggers and procedures in MySQL: > Hi All, > > I am looking into putting triggers, procedures and into MySQL. > > The tools I am using seem to lack this fa

Creating Triggers and procedures in MySQL

2003-10-05 Thread Gregory Hicks
Hi All, I am looking into putting triggers, procedures and into MySQL. The tools I am using seem to lack this facility, unless MySQL doesnot actually have these important database features. Any help is appreciated. Gregory Hicks Database Analyst Programmer -- MySQL General Mailing List For