MySQL Forums
Forum List  »  Triggers

Mysql Trigger
Posted by: Peter Joole
Date: December 08, 2011 03:00PM

Hi,

I want to implement a trigger that when an insert happens in one table, it does a couple of inserts into another table. The problem is that I don't know if its possible to do.

Table Person has
=> Family name
=> First name

Table Kring
=> Kring Id
=> Kring text

Now how can you trigger it:

Create automateKringCreation after insert on Person
begin
Insert into Kring(`text`) values('banaan');
end

But it doesn't work.

Can someone help me?

Options: ReplyQuote


Subject
Views
Written By
Posted
Mysql Trigger
1826
December 08, 2011 03:00PM
935
December 09, 2011 06:12AM


Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.