Sqlx: mysql query error

[liangyongrui]

dependencies

[dependencies.sqlx]
git = 'https://github.com/launchbadge/sqlx.git'
features = ['mysql']

when I try query：

println!("123");
let pool = sqlx::MySqlPool::new("mysql://xxx:xxx@xxx:xxx/rimer").await?;
let mut conn = pool.acquire().await?;
println!("456");
sqlx::query(r"DELETE FROM rimer_trigger_job WHERE job_id = ?")
    .bind(job_id)
    .fetch_one(&mut *conn)
    .await?;
println!("789");

I got the following error：

123
456
thread 'test_schedule_job' panicked at 'called `Result::unwrap()` on an `Err` value: NotFound', src/libcore/result.rs:1165:5

[liangyongrui]

Issue #22 is not resolved

[abonander]

@liangyongrui you're not returning anything from the DELETE; fetch_one() expects exactly one row returned in the result. Use .execute() instead for purely side-effecting queries.

[liangyongrui]

@abonander Thank you very much, I succeeded!