Mysql Trigger
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?
Subject
Views
Written By
Posted
Mysql Trigger
2006
December 08, 2011 03:00PM
1025
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.