INSERT INTO table_name(username,password)
select '张山','8495461'
FROM DUAL (DUAL 是mysql内置的一张表)
WHERE not EXISTS (SELECT id FROM table_nameWHERE username='张山' and password='8495461');
INSERT INTO table_name(username,password)
select '张山','8495461'
FROM DUAL (DUAL 是mysql内置的一张表)
WHERE not EXISTS (SELECT id FROM table_nameWHERE username='张山' and password='8495461');