Rust code example to access MySQL

The mysql crate in Rust provides a client library for interacting with MySQL databases. It allows Rust programs to connect to MySQL servers, execute queries (both SQL and prepared statements), handle results, and manage transactions, all within a safe and idiomatic Rust environment. It offers features like connection pooling and asynchronous operations for improved performance and efficiency.

To access a MySQL server using Rust, you can use the mysql crate, which provides a simple and efficient interface for working with MySQL databases. Here's an example of how to connect to a MySQL server and execute a query:

Cargo.toml

First, add the mysql crate to your Cargo.toml:

[dependencies]
mysql = "23.1.0"  # Check for the latest version

Rust Code

Here's an example of a Rust program that connects to a MySQL server, executes a query, and prints the results:

use mysql::*;
use mysql::prelude::*;

fn main() -> Result<()> {
    // Define the database connection options
    let database_url = "mysql://username:password@localhost:3306/database_name";

    // Establish a connection to the database
    let pool = Pool::new(database_url)?;
    let mut conn = pool.get_conn()?;

    // Example: Create a table
    conn.query_drop(
        r"CREATE TABLE IF NOT EXISTS users (
            id INT PRIMARY KEY AUTO_INCREMENT,
            name VARCHAR(255) NOT NULL,
            age INT NOT NULL
        )",
    )?;

    // Example: Insert data
    conn.exec_drop(
        "INSERT INTO users (name, age) VALUES (:name, :age)",
        params! {
            "name" => "Alice",
            "age" => 30,
        },
    )?;

    // Example: Query data
    let selected_users: Vec<(u32, String, u32)> = conn.query("SELECT id, name, age FROM users")?;
    for user in selected_users {
        println!("ID: {}, Name: {}, Age: {}", user.0, user.1, user.2);
    }

    Ok(())
}

Explanation

1. Database URL: Replace username, password, and database_name with your actual MySQL credentials and database name.
2. Pool: Creates a pool of connections for efficient reuse.
3. query_drop: Executes a query that doesn't return data, like CREATE TABLE or INSERT.
4. query: Executes a query that returns data, like SELECT.

Running the Program

1. Make sure your MySQL server is running and accessible.
2. Replace the placeholder credentials in the code with actual values.

3. Compile and run the program:

   cargo run
   

This example demonstrates basic CRUD operations. Depending on your use case, you can extend it further to handle more complex queries and error management.