need example for Triggers

[donilourdu]

hi I am doni

I need example for tigger in MySQL database.

looking for replies

with regards,
doni

[ronverdonk]

In assume you do not mean TIGGERS but TRIGGERS?
What have you done to get the info from the standard MySQL documentation?That shows samples. See Triggers

You also do not specify for what situation you'd need it. Do we have to guess?

Ronald :cool:

[donilourdu]

In assume you do not mean TIGGERS but TRIGGERS?
What have you done to get the info from the standard MySQL documentation?That shows samples. See Triggers

You also do not specify for what situation you'd need it. Do we have to guess?

Ronald :cool:

thank you for reply
well Ronald I already know that site. But It cant be clear for me. Could you give me a simple example

[ronverdonk]

Okay, this is a simple example.
Assume: each time a row is inserted in table MyTable you want to log that event by adding a row to LogTable.

CREATE TRIGGER logit AFTER INSERT ON MyTable
FOR EACH ROW 
BEGIN
  INSERT INTO LogTable (timestamp, message)
  VALUES(NOW(), 'row added to MyTable');
END;
 

A good article with samples is shown at the OnLamp site at MySQL Triggers tryout

Ronald :cool:

[donilourdu]

[thank you Very much Ronald for your example.
It realy helpful for me.

with regards,
Doni

Okay, this is a simple example.
Assume: each time a row is inserted in table MyTable you want to log that event by adding a row to LogTable.

CREATE TRIGGER logit AFTER INSERT ON MyTable
FOR EACH ROW 
BEGIN
  INSERT INTO LogTable (timestamp, message)
  VALUES(NOW(), 'row added to MyTable');
END;
 

A good article with samples is shown at the OnLamp site at MySQL Triggers tryout

Ronald :cool: