MySQL防止重复插入记录SQL

 

INSERT INTO sysuser(UserName,PASSWORD,CreateTime)
SELECT '1231','123',NOW() FROM DUAL WHERE NOT EXISTS(SELECT * FROM sysuser WHERE UserName='1231')

 

DUAL:表示虚拟表

sysuser：表名称