DELIMITER $$ CREATE TRIGGER trigger1 BEFORE INSERT ON `budget` FOR EACH ROW BEGIN if CHAR_LENGTH(NEW.`Cod_Ag`) <> 5 or (select NEW.`Cod_Ag`) not regexp '[0-9][0-9][0-9][0-9][0-9]' then call something; END IF; if CHAR_LENGTH(NEW.`Cod_Ind`) <> 7 or (select NEW.`Cod_Ind`) not regexp '[A-Z][A-Z][A-Z][0-9][0-9][0-9][0-9]' then call something; END IF; END$$ DELIMITER;
L'utilisateur ne peut saisir que 5 caractères