如果存在两个值，则不插入PHP / SQL

Question

I only want to insert if there are no entries where "name" and "email" exist together.

So it's ok if "name" exists with a different e-mail or vica versa.

mysql_query("INSERT INTO list (name,email) VALUES ('$name','$email') ");

I want this done in one SQL statement for bette performance.

Answer 1

Make both the columns (name,email) as composite primary key and use ON DUPLICATE KEY UPDATE to prevent php errors.