Function convert_table_to_jsonb 

pub async fn convert_table_to_jsonb(
    conn: &mut Conn,
    db_name: &str,
    table_name: &str,
) -> Result<Vec<(String, Value)>>

Convert an entire MySQL table to JSONB format

Reads all rows from the table and converts them to (id, jsonb_data) tuples. The ID is extracted from a primary key or auto-generated.

Arguments

• conn - MySQL connection
• db_name - Database name
• table_name - Table name

Returns

Vector of (id, json_data) tuples ready for PostgreSQL JSONB storage

Examples

let mut conn = connect_mysql("mysql://localhost:3306/mydb").await?;
let rows = convert_table_to_jsonb(&mut conn, "mydb", "users").await?;
println!("Converted {} rows", rows.len());