Creating Triggers

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

creating triggers?

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

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 facility, unless MySQL doesnot actually have these important database features. Any help is appreciated. Gregory Hicks Database Analyst Programmer -- MySQL General Mailing List For

Re: Creating Triggers and procedures in MySQL

. 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 facility, unless MySQL doesnot actually have these important

Re: Creating Triggers and procedures in MySQL

in the lengthy discussion, you 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