How do I use fetch_many / execute_many ?

[kyku]

In my sample program I'm trying to do the following:

use futures::StreamExt;
use sqlx::Connection;

#[tokio::main]
async fn main() {
    let mut conn = sqlx::MySqlConnection::connect("mysql://user:pass@localhost/db")
        .await
        .unwrap();

    let mut s = sqlx::query(concat!(
        "UPDATE foo SET bar=false WHERE id=34;",
        "UPDATE foo SET bar=true WHERE id=43;"
    ))
    .execute_many(&mut conn)
    .await;

    while let Some(k) = s.next().await {
        println!("{k:?}");
    }
}

But MySql complains with You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near 'UPDATE error. So the question is how one is supposed to pass multiple queries so that they are properly recognized.

[istx25]

Did you ever figure this out?

[VersBinarii]

Its been a while since i worked with MySql but i remember something about MySql disallowing multiple statements by default. So this is something you need to possibly enable explicitly with config options. Assuming Sqlx supports it

[kyku]

I've browsed through sqlx's MySql driver a bit and it enables the multi-statements when configuring the connection by default.

[udoless]

@kyku Had you solved this?