On Wednesday 19 April 2006 11:10, Lucas Vendramin wrote:
> Hi all.
> I am creating a trigger that update the some table witch call it.
> Ex:
> create table t1 (
> id int, name varchar(50), c int default 0, father int,
> primary key(id),
> index (father),
> foreign key (father) references t1(id)
Hi.
Anyone know how to create a trigger that update the table that invoked it?
--
Hi all.
I am creating a trigger that update the some table witch call it.
Ex:
create table t1 (
id int, name varchar(50), c int default 0, father int,
primary key(id),
index (father),
foreign key (father
Hi all.
I am creating a trigger that update the some table witch call it.
Ex:
create table t1 (
id int, name varchar(50), c int default 0, father int,
primary key(id),
index (father),
foreign key (father) references t1(id) on update restrict on delete restrict
);
create trigger tg_t1
before upd
