thanx it works the trigger is created successfully but it has no
effect. here it is:
delimiter //
create trigger testref before insert on bookmarks
for each row
begin
declare dummy char(2);
if new.title like '%xxx%'
then
set new.id='xxx';
end if;
end;
//create trigger testref before insert on bookmarks
-> for each row
-> begin
-> declare dummy char(2);
-> if new.title like '%xxx%'
-> then
-> set dummy = 'xxx';
-> end if;
-> end;
-> //
then:
insert into bookmarks values (1, "xxxxx");
Query OK, 1 row affected, 1 warning (0.00 sec)
the row is created with a warning. I would like to prevent it from
being created. I would like the insert to be canceled if the value is
equal to xxx.
any idea how to cancel the insert?
thanx in advance
Pat
