MYSQL 去重触发器 并且允许空值重复的策略

DELIMITER //
CREATE TRIGGER `kill_repeats` BEFORE INSERT ON `table_name`
 FOR EACH ROW BEGIN   
    if NEW.name1<>'' and NEW.name1 in (select name1 from table_name)
    then  SIGNAL SQLSTATE 'Q001' SET MESSAGE_TEXT = 'name1 has been exsits';  
    end if;
    if NEW.name2<>'' and NEW.name2 in (select name2 from table_name)
    then  SIGNAL SQLSTATE 'Q001' SET MESSAGE_TEXT = 'name2 has been exsits';  
    end if;
    if NEW.name3<>'' and NEW.name3 in (select name3 from table_name)
    then  SIGNAL SQLSTATE 'Q001' SET MESSAGE_TEXT = 'name3 has been exsits';  
    end if;
    /*需要检测多少个字段就可以重复几次*/
END

上面是创建一个触发器的代码，目前已经是解了我的燃眉之急，但是在性能上可能没有保证，还望各位数据库领域的大佬加以之指正。

代码里面的table_name、name1、name2、name3、信号值、信息等字段请自行替换。当然，这个只是分享一下，毕竟是在学习的过程中。