Re: AFTER Delete Trigger question

As far as I know, you can´t change data on the same table in triggers. "Kevin Labecot" escreveu na mensagem news:4d2ce38b-d169-478b-aebf-c19f20dce...@labecot.fr... Hi, Is there a way to update the same table on a delete trigger ? I need to call an UPDATE statement when a delete occurs.

AFTER Delete Trigger question

Hi,Is there a way to update the same table on a delete trigger ?I need to call an UPDATE statement when a delete occurs.Best regards -- Kevin Labecot, Innovanticwww.innovantic.frTél. : 05.56.45.60.54

Re: Another Trigger Question!

In the last episode (Jul 09), Marcel Grandemange said: > Create Trigger hostchange > BEFORE UPDATE ON host > FOR EACH ROW > BEGIN > IF NEW.status != OLD.status THEN > use smsgw; > insert into outbox (number, insertdate, text, phone, dreport) VALUES > ('0836075144', '', 'HostDown', '1', '1')"); > EN

Another Trigger Question!

Good Day once again. Im needing assistance again with triggers! Create Trigger hostchange BEFORE UPDATE ON host FOR EACH ROW BEGIN IF NEW.status != OLD.status THEN use smsgw; insert into outbox (number, insertdate, text, phone, dreport) VALUES ('0836075144', '', 'HostDown', '1', '1

RE: trigger question..

uldn't be set prior to the row being created... any more pointers/thoughts/... thanks -Original Message- From: joe [mailto:[EMAIL PROTECTED] Sent: Wednesday, December 19, 2007 7:33 PM To: 'bruce'; 'mysql list' Subject: RE: trigger question.. create ta

RE: trigger question..

Original Message- From: bruce [mailto:[EMAIL PROTECTED] Sent: Wednesday, December 19, 2007 7:59 PM To: 'mysql list' Subject: trigger question.. hi. using mysql 5.0.27 and playing with triggers. a simple db: create table foo{ aa varchar (10), bb int auto_increment, cc varchar

trigger question..

hi. using mysql 5.0.27 and playing with triggers. a simple db: create table foo{ aa varchar (10), bb int auto_increment, cc varchar (10), } innondb i'm trying to figure out how to create a trigger, such that if the user does an insert into foo (cc) value ("www"); the table will concat the ww

Re: trigger question...

Hi Bruce, > delimiter | > create trigger mfgtst after insert on masterHostTBL > > for each row begin > set @tmp = 55; > insert into masterTestResultStartTBL > set hostID = NEW.id, > testResultVal = 88; > > /* > set @q = masterTestResultStartValTBL.serverStartVal

trigger question...

hi... i have the following test sql/schema. i'm trying to create a trigger that would allow an item in tbl2 to be updated, based upon values from the tbl that's being inserted into, and the value in a 2nd tbl.element. the sql/schema: /* test schema for stratalight file project # # b douglas # #3

Re: Trigger question

Baron, Thanks a lot Adding the columns to the end works... Olaf On 5/30/07 2:13 PM, "Baron Schwartz" <[EMAIL PROTECTED]> wrote: > Hi, > > Olaf Stein wrote: >> Hey all, >> >> I asked this before (a while back) and have gotten some answers that solve >> my problem partially only. >> >> --

RE: Trigger question

foshop.com www.giiexpress.com www.etudes-marche.com > -Original Message- > From: Olaf Stein [mailto:[EMAIL PROTECTED] > Sent: Wednesday, May 30, 2007 2:05 PM > To: MySql > Subject: Trigger question > > Hey all, > > I asked this before (a while back) and have gotten s

Re: Trigger question

Hi, Olaf Stein wrote: Hey all, I asked this before (a while back) and have gotten some answers that solve my problem partially only. --- old message -- I have a table with 205 columns. When an update statement updates a row in this table I want a trigger that creates a record of t

Trigger question

Hey all, I asked this before (a while back) and have gotten some answers that solve my problem partially only. --- old message -- I have a table with 205 columns. When an update statement updates a row in this table I want a trigger that creates a record of the old row in a separate

Specific mysql Trigger question

mysql ver 5.0.26 standard Can a trigger call a procedure that returns a result set? I am trying to get around this error msg. ERROR 1415 (0A000): Not allowed to return a result set from a trigger Thanks -winn Below is a more concise description of my issue and logic pattern when a record is

silly trigger question

Hi, Would something like this make it so that every time there was a new row inserted on TEST, a row with the new values was inserted on LOG_TABLE? I am not sure if you can reference NEW.id and all the NEW values directly and send them in a trigger... Thanks... CREATE TRIGGER test.data_table_au