insert in mysql

“INSERT ~ ON DUPLICATE KEY UPDATE” which implies an unnecessary update at some cost

“INSERT IGNORE” which implies an invitation for other kinds of failure to slip in unannounced.