插入不重复

INSERT INTO ez_book_detail (`BookID`,`Sign`,`Update`) SELECT 1,'222',333 FROM DUAL WHERE  NOT EXISTS (SELECT * FROM ez_book_detail WHERE `Sign`='222')

INSERT INTO table (a,b,c) VALUES (1,2,3)    ON DUPLICATE KEY UPDATE c=c;