mysql的防重复插入数据的sql

1、insert where

INSERT INTO account (usernumber,money,username) SELECT 'a',3,'aa' FROM DUAL WHERE NOT EXISTS (SELECT money FROM account WHERE money = 10200) 

2、insert ignore into 

 INSERT IGNORE INTO account (username) VALUES ('MySQL Manual')