thanx it works the trigger is created successfully but it has no
effect. here it is:
create trigger testref before insert on bookmarks
for each row
declare dummy char(2);
if new.title like '%xxx%'
//create trigger testref before insert on bookmarks
-> for each row
-> declare dummy char(2);
-> if new.title like '%xxx%'
-> set dummy = 'xxx';
-> end if;
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