Mysql Trigger

[Peter Joole]

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?