Kohan biblioitems-taulun triggerit¶

MariaDB 5.6-10.0¶

delimiter $$
create trigger insert_remove_hyphens
   before insert on biblioitems
   for each row
begin
   set new.isbn = REPLACE(new.isbn,'-',''), new.ean = REPLACE(new.ean,'-','');
end$$
delimiter ;

delimiter $$
create trigger update_remove_hyphens
   before update on biblioitems
   for each row
begin
   set new.isbn = REPLACE(new.isbn,'-',''), new.ean = REPLACE(new.ean,'-','');
end$$
delimiter ;

MariaDB 10.1 =<¶

CREATE OR REPLACE DEFINER=`<user>`@`<host>` TRIGGER insert_remove_hyphens
  BEFORE INSERT ON biblioitems FOR EACH ROW 
   SET new.isbn = REPLACE(new.isbn,'-',''), new.ean = REPLACE(new.ean,'-','');

CREATE OR REPLACE DEFINER=`<user>`@`<host>` TRIGGER update_remove_hyphens
  BEFORE UPDATE ON biblioitems FOR EACH ROW
   SET new.isbn = REPLACE(new.isbn,'-',''), new.ean = REPLACE(new.ean,'-','');