Databáze a jazyk SQL

SQL

insert a record without first checking if the primary key you want to use has already been used
INSERT IGNORE INTO mytable

Finding duplicate items in sql table:
SELECT email,
 COUNT(email) AS NumOccurrences
FROM User
GROUP BY email
HAVING ( COUNT(email) > 1 )