INSERT INTO sysuser(UserName,PASSWORD,CreateTime)
SELECT '1231','123',NOW() FROM DUAL WHERE NOT EXISTS(SELECT * FROM sysuser WHERE UserName='1231')
DUAL:表示虚拟表
sysuser:表名称
INSERT INTO sysuser(UserName,PASSWORD,CreateTime)
SELECT '1231','123',NOW() FROM DUAL WHERE NOT EXISTS(SELECT * FROM sysuser WHERE UserName='1231')
DUAL:表示虚拟表
sysuser:表名称
转载于:https://www.cnblogs.com/wms01/p/6277276.html