使用数据库(DB)

// Connect to the database
// ...

let sql = """
    DELETE FROM city
    WHERE ID = ?
"""

var pointer: OpaquePointer?
sqlite3_prepare_v2(db, sql, -1, &pointer, nil)
sqlite3_bind_int(pointer, 12)

if sqlite3_step(pointer) != SQLITE_DONE {
    let errmsg = String(cString: sqlite3_errmsg(db)!)
    print("record deletion error: \(errmsg)")
}

sqlite3_finalize(pointer)