pub fn replace_into<T>(target: T) -> IncompleteInsertStatement<T, Replace>
Expand description

Creates a REPLACE statement.

If a constraint violation fails, the database will attempt to replace the offending row instead. This function is only available with MySQL and SQLite.

Example

replace_into(users)
    .values(&vec![
        (id.eq(1), name.eq("Sean")),
        (id.eq(2), name.eq("Tess")),
    ])
    .execute(&conn)
    .unwrap();

replace_into(users)
    .values((id.eq(1), name.eq("Jim")))
    .execute(&conn)
    .unwrap();

let names = users.select(name).order(id).load::<String>(&conn);
assert_eq!(Ok(vec!["Jim".into(), "Tess".into()]), names);