insertIgnoreAndGetId

suspend fun <Key : Any, T : IdTable<Key>> T.insertIgnoreAndGetId(body: T.(UpdateBuilder<*>) -> Unit): EntityID<Key>?

Represents the SQL statement that inserts a new row into a table, while ignoring any possible errors that occur during the process.

For example, if the new row would violate a unique constraint, its insertion would be ignored. Note: INSERT IGNORE is not supported by all vendors. Please check the documentation.

Return

The generated ID for the new row, or null if none was retrieved after statement execution.

Samples

org.jetbrains.exposed.v1.r2dbc.sql.tests.shared.dml.InsertTests.testInsertIgnoreAndGetId01