MySQL Lists are EOL. Please join:

List:General Discussion« Previous MessageNext Message »
From:John Brittingham Date:December 31 2005 2:14am
Subject:creating triggers?
View as plain text  
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 number of CUIDS for that date and time if it does. 

I have never done anything with triggers and wonder if this is possible?


John Brittingham

Marketing and Customer Systems 

Desk: 425-288-8071

Cell: 425-770-0458


creating triggers?John Brittingham31 Dec