Changes an insert into query to an insert ignore into query.

If you use the ignore modifier, ignorable errors that occur while executing the insert statement are ignored. For example, without ignore, a row that duplicates an existing unique index or primary key value in the table causes a duplicate-key error and the statement is aborted. With ignore, the row is discarded and no error occurs.

This is only supported on some dialects like MySQL. On most dialects you should use the {@link onConflict} method.

Examples

await db.insertInto('person')
  .ignore()
  .values(values)
  .execute()