problem in creating a trigger

Posted by mohanish on Stack Overflow See other posts from Stack Overflow or by mohanish
Published on 2010-05-05T04:15:40Z Indexed on 2010/05/05 4:18 UTC
Read the original article Hit count: 137

Filed under:

mysql-triggers

Hi Bill

I am facing a problem in creating a trigger and i am not sure why this is erroring out.can you please help me.

I have described the problem in this link below

http://forums.mysql.com/read.php?99,365942,365942#msg-365942.

Related posts about mysql-triggers

help with mysql triggers (checking values before insert)

as seen on Stack Overflow - Search for 'Stack Overflow'
hi I'm quite new to mysql and I'm trying to figure out how to use triggers. what I'm trying to do: I have 2 tables, max and sub_max, when I insert a new row to sub_max I want to check if the SUM of the values with the same foreign_key as the new row are less than the value in the max table. I think… >>> More
How to group data changes by operation with MySQL triggers

as seen on Stack Overflow - Search for 'Stack Overflow'
I am using triggers in MySQL to log changes to the data. These changes are recorded on a row level. I can now insert an entry in my log table for each row that is changed. However, I also need to record the operation to which the changes belong. For example, a delete operation like "DELETE * FROM… >>> More
MySQL Triggers to Disable A User Account

as seen on Stack Overflow - Search for 'Stack Overflow'
I am trying to create a MySQL Trigger to disable someone's account if they have logged in to the site 3 times. I have tried to create this trigger using the following code, but it is not setting is_active to 0 no matter what times_logged_in is. Any help would be appreciated. CREATE TRIGGER updateTrigger… >>> More
Problem importing mysql triggers generated from mysqldump

as seen on Stack Overflow - Search for 'Stack Overflow'
I am using phpmyadmin for using the mysqldump query, but as per my requirement i have to create a new database which is clone of the previous one, now in this case when i import the main DB it contain all the trigger information as well with the DB name mentioned in it.. As i import this DB to new… >>> More
MySQL triggers and selecting data inside the trigger?

as seen on Stack Overflow - Search for 'Stack Overflow'
Does anyone know if you can run a select statement to return values on the table that the trigger is assigned to from inside the trigger? Thanks in advance. >>> More

Developer IT

problem in creating a trigger - Developer IT

problem in creating a trigger

mysql-triggers

Related posts about mysql-triggers

help with mysql triggers (checking values before insert)

How to group data changes by operation with MySQL triggers

MySQL Triggers to Disable A User Account

Problem importing mysql triggers generated from mysqldump

MySQL triggers and selecting data inside the trigger?

Categories cloud