Struct MySqlConnection 

pub struct MySqlConnection { /* private fields */ }

MySQL connection.

Manages a TCP connection to a MySQL server, handling the wire protocol, authentication, and state tracking.

Implementations

impl MySqlConnection

pub fn connect(config: MySqlConfig) -> Result<Self, Error>

Establish a new connection to the MySQL server.

This performs the complete connection handshake:

1. TCP connection
2. Receive server handshake
3. Send handshake response with authentication
4. Handle auth result (possibly auth switch)

pub fn state(&self) -> ConnectionState

Get the current connection state.

pub fn is_ready(&self) -> bool

Check if the connection is ready for queries.

pub fn connection_id(&self) -> u32

Get the connection ID.

pub fn server_version(&self) -> Option<&str>

Get the server version.

pub fn affected_rows(&self) -> u64

Get the number of affected rows from the last statement.

pub fn last_insert_id(&self) -> u64

Get the last insert ID.

pub fn warnings(&self) -> u16

Get the number of warnings from the last statement.

pub fn query_sync( &mut self, sql: &str, params: &[Value], ) -> Result<Vec<Row>, Error>

Execute a text protocol query with parameters (synchronous).

Returns a vector of rows for SELECT queries, or empty for other statements. Parameters are interpolated into the SQL string with proper escaping.

pub fn query_one_sync( &mut self, sql: &str, params: &[Value], ) -> Result<Option<Row>, Error>

Execute a query and return the first row, if any (synchronous).

pub fn execute_sync( &mut self, sql: &str, params: &[Value], ) -> Result<u64, Error>

Execute a statement that doesn’t return rows (synchronous).

pub fn insert_sync(&mut self, sql: &str, params: &[Value]) -> Result<i64, Error>

Execute an INSERT and return the last inserted ID (synchronous).

pub fn ping(&mut self) -> Result<(), Error>

Ping the server to check connection.

pub fn close(self) -> Result<(), Error>

Close the connection gracefully.

Trait Implementations

impl Debug for MySqlConnection

fn fmt(&self, f: &mut Formatter<'_>) -> Result

Formats the value using the given formatter.