In SQL we support non-standard clause called ON CONFLICT / OR. It is not a separate clause which can appear in INSERT/UPDATE statements or as a column option in CREATE TABLE statements. See examples ...

The MySQL database server software, which powers many websites and business applications, uses a dialect of the industry-standard Structured Query Language for database maintenance and transaction ...

database_name Is the database name in which the specified table or view resides. If not specified, this is the current database. table_name Is the name of the table or view to bulk import data into.

The problem is i need to perform this query about 85 times because the value '1001' is different for each entry. What is the right way of typing this SQL query to accomplish the above without having ...