Struct sqlx::MySql

pub struct MySql;

This is supported on feature="mysql" only.

MySQL database driver.

Trait Implementations

impl Database for MySql

type Connection = MySqlConnection

The concrete Connection implementation for this database.

type Arguments = MySqlArguments

The concrete Arguments implementation for this database.

type TypeInfo = MySqlTypeInfo

The concrete TypeInfo implementation for this database.

type TableId = Box<str>

The Rust type of table identifiers for this database.

type RawBuffer = Vec<u8>

The Rust type used as the buffer when encoding arguments.

type Error = MySqlError

The concrete DatabaseError type used to report errors from the database.

impl Debug for MySql

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

Formats the value using the given formatter.

impl<'_> Decode<'_, MySql> for BigDecimal

fn decode(value: MySqlValue) -> Result<BigDecimal, Error>

impl<'de> Decode<'de, MySql> for Time

fn decode(value: MySqlValue<'de>) -> Result<Time, Error>

impl<'de> Decode<'de, MySql> for u8

fn decode(value: MySqlValue<'de>) -> Result<u8, Error>

impl<'de> Decode<'de, MySql> for u32

fn decode(value: MySqlValue<'de>) -> Result<u32, Error>

impl<'de> Decode<'de, MySql> for i64

fn decode(value: MySqlValue<'de>) -> Result<i64, Error>

impl<'de> Decode<'de, MySql> for NaiveDate

fn decode(buf: MySqlValue<'de>) -> Result<NaiveDate, Error>

impl<'de> Decode<'de, MySql> for PrimitiveDateTime

fn decode(value: MySqlValue<'de>) -> Result<PrimitiveDateTime, Error>

impl<'de> Decode<'de, MySql> for OffsetDateTime

fn decode(value: MySqlValue<'de>) -> Result<OffsetDateTime, Error>

impl<'de> Decode<'de, MySql> for Vec<u8>

fn decode(value: MySqlValue<'de>) -> Result<Vec<u8>, Error>

impl<'de> Decode<'de, MySql> for &'de [u8]

fn decode(value: MySqlValue<'de>) -> Result<&'de [u8], Error>

impl<'de> Decode<'de, MySql> for String

fn decode(value: MySqlValue<'de>) -> Result<String, Error>

impl<'de> Decode<'de, MySql> for u64

fn decode(value: MySqlValue<'de>) -> Result<u64, Error>

impl<'de> Decode<'de, MySql> for i32

fn decode(value: MySqlValue<'de>) -> Result<i32, Error>

impl<'de> Decode<'de, MySql> for bool

fn decode(value: MySqlValue<'de>) -> Result<bool, Error>

impl<'de> Decode<'de, MySql> for NaiveDateTime

fn decode(buf: MySqlValue<'de>) -> Result<NaiveDateTime, Error>

impl<'de> Decode<'de, MySql> for i8

fn decode(value: MySqlValue<'de>) -> Result<i8, Error>

impl<'de> Decode<'de, MySql> for f64

fn decode(value: MySqlValue<'de>) -> Result<f64, Error>

impl<'de> Decode<'de, MySql> for DateTime<Utc>

fn decode(value: MySqlValue<'de>) -> Result<DateTime<Utc>, Error>

impl<'de> Decode<'de, MySql> for f32

fn decode(value: MySqlValue<'de>) -> Result<f32, Error>

impl<'de> Decode<'de, MySql> for &'de str

fn decode(value: MySqlValue<'de>) -> Result<&'de str, Error>

impl<'de> Decode<'de, MySql> for Date

fn decode(value: MySqlValue<'de>) -> Result<Date, Error>

impl<'de> Decode<'de, MySql> for i16

fn decode(value: MySqlValue<'de>) -> Result<i16, Error>

impl<'de> Decode<'de, MySql> for NaiveTime

fn decode(buf: MySqlValue<'de>) -> Result<NaiveTime, Error>

impl<'de> Decode<'de, MySql> for u16

fn decode(value: MySqlValue<'de>) -> Result<u16, Error>

impl<'de, T> Decode<'de, MySql> for Option<T> where
    T: Decode<'de, MySql>, 

fn decode(value: MySqlValue<'de>) -> Result<Option<T>, Error>

impl Encode<MySql> for Vec<u8>

fn encode(&self, buf: &mut Vec<u8>)

Writes the value of self into buf in the expected format for the database.

fn encode_nullable(&self, buf: &mut <DB as Database>::RawBuffer) -> IsNull

fn size_hint(&self) -> usize

impl Encode<MySql> for u32

fn encode(&self, buf: &mut Vec<u8>)

Writes the value of self into buf in the expected format for the database.

fn encode_nullable(&self, buf: &mut <DB as Database>::RawBuffer) -> IsNull

fn size_hint(&self) -> usize

impl Encode<MySql> for PrimitiveDateTime

fn encode(&self, buf: &mut Vec<u8>)

Writes the value of self into buf in the expected format for the database.

fn size_hint(&self) -> usize

fn encode_nullable(&self, buf: &mut <DB as Database>::RawBuffer) -> IsNull

impl Encode<MySql> for OffsetDateTime

fn encode(&self, buf: &mut Vec<u8>)

Writes the value of self into buf in the expected format for the database.

fn encode_nullable(&self, buf: &mut <DB as Database>::RawBuffer) -> IsNull

fn size_hint(&self) -> usize

impl Encode<MySql> for NaiveTime

fn encode(&self, buf: &mut Vec<u8>)

Writes the value of self into buf in the expected format for the database.

fn size_hint(&self) -> usize

fn encode_nullable(&self, buf: &mut <DB as Database>::RawBuffer) -> IsNull

impl Encode<MySql> for i8

fn encode(&self, buf: &mut Vec<u8>)

Writes the value of self into buf in the expected format for the database.

fn encode_nullable(&self, buf: &mut <DB as Database>::RawBuffer) -> IsNull

fn size_hint(&self) -> usize

impl Encode<MySql> for NaiveDateTime

fn encode(&self, buf: &mut Vec<u8>)

Writes the value of self into buf in the expected format for the database.

fn size_hint(&self) -> usize

fn encode_nullable(&self, buf: &mut <DB as Database>::RawBuffer) -> IsNull

impl Encode<MySql> for Time

fn encode(&self, buf: &mut Vec<u8>)

Writes the value of self into buf in the expected format for the database.

fn size_hint(&self) -> usize

fn encode_nullable(&self, buf: &mut <DB as Database>::RawBuffer) -> IsNull

impl Encode<MySql> for u8

fn encode(&self, buf: &mut Vec<u8>)

Writes the value of self into buf in the expected format for the database.

fn encode_nullable(&self, buf: &mut <DB as Database>::RawBuffer) -> IsNull

fn size_hint(&self) -> usize

impl Encode<MySql> for u16

fn encode(&self, buf: &mut Vec<u8>)

Writes the value of self into buf in the expected format for the database.

fn encode_nullable(&self, buf: &mut <DB as Database>::RawBuffer) -> IsNull

fn size_hint(&self) -> usize

impl Encode<MySql> for i64

fn encode(&self, buf: &mut Vec<u8>)

Writes the value of self into buf in the expected format for the database.

fn encode_nullable(&self, buf: &mut <DB as Database>::RawBuffer) -> IsNull

fn size_hint(&self) -> usize

impl Encode<MySql> for DateTime<Utc>

fn encode(&self, buf: &mut Vec<u8>)

Writes the value of self into buf in the expected format for the database.

fn encode_nullable(&self, buf: &mut <DB as Database>::RawBuffer) -> IsNull

fn size_hint(&self) -> usize

impl Encode<MySql> for bool

fn encode(&self, buf: &mut Vec<u8>)

Writes the value of self into buf in the expected format for the database.

fn encode_nullable(&self, buf: &mut <DB as Database>::RawBuffer) -> IsNull

fn size_hint(&self) -> usize

impl Encode<MySql> for i32

fn encode(&self, buf: &mut Vec<u8>)

Writes the value of self into buf in the expected format for the database.

fn encode_nullable(&self, buf: &mut <DB as Database>::RawBuffer) -> IsNull

fn size_hint(&self) -> usize

impl Encode<MySql> for u64

fn encode(&self, buf: &mut Vec<u8>)

Writes the value of self into buf in the expected format for the database.

fn encode_nullable(&self, buf: &mut <DB as Database>::RawBuffer) -> IsNull

fn size_hint(&self) -> usize

impl Encode<MySql> for i16

fn encode(&self, buf: &mut Vec<u8>)

Writes the value of self into buf in the expected format for the database.

fn encode_nullable(&self, buf: &mut <DB as Database>::RawBuffer) -> IsNull

fn size_hint(&self) -> usize

impl Encode<MySql> for [u8]

fn encode(&self, buf: &mut Vec<u8>)

Writes the value of self into buf in the expected format for the database.

fn encode_nullable(&self, buf: &mut <DB as Database>::RawBuffer) -> IsNull

fn size_hint(&self) -> usize

impl Encode<MySql> for NaiveDate

fn encode(&self, buf: &mut Vec<u8>)

Writes the value of self into buf in the expected format for the database.

fn size_hint(&self) -> usize

fn encode_nullable(&self, buf: &mut <DB as Database>::RawBuffer) -> IsNull

impl Encode<MySql> for Date

fn encode(&self, buf: &mut Vec<u8>)

Writes the value of self into buf in the expected format for the database.

fn size_hint(&self) -> usize

fn encode_nullable(&self, buf: &mut <DB as Database>::RawBuffer) -> IsNull

impl Encode<MySql> for str

fn encode(&self, buf: &mut Vec<u8>)

Writes the value of self into buf in the expected format for the database.

fn encode_nullable(&self, buf: &mut <DB as Database>::RawBuffer) -> IsNull

fn size_hint(&self) -> usize

impl Encode<MySql> for String

fn encode(&self, buf: &mut Vec<u8>)

Writes the value of self into buf in the expected format for the database.

fn encode_nullable(&self, buf: &mut <DB as Database>::RawBuffer) -> IsNull

fn size_hint(&self) -> usize

impl Encode<MySql> for f64

fn encode(&self, buf: &mut Vec<u8>)

Writes the value of self into buf in the expected format for the database.

fn encode_nullable(&self, buf: &mut <DB as Database>::RawBuffer) -> IsNull

fn size_hint(&self) -> usize

impl Encode<MySql> for f32

fn encode(&self, buf: &mut Vec<u8>)

Writes the value of self into buf in the expected format for the database.

fn encode_nullable(&self, buf: &mut <DB as Database>::RawBuffer) -> IsNull

fn size_hint(&self) -> usize

impl Encode<MySql> for BigDecimal

fn encode(&self, buf: &mut Vec<u8>)

Writes the value of self into buf in the expected format for the database.

fn size_hint(&self) -> usize

fn encode_nullable(&self, buf: &mut <DB as Database>::RawBuffer) -> IsNull

impl<'c, 'q> HasCursor<'c, 'q> for MySql

type Database = MySql

type Cursor = MySqlCursor<'c, 'q>

The concrete Cursor implementation for this database.

impl<'c> HasRawValue<'c> for MySql

type Database = MySql

type RawValue = MySqlValue<'c>

The Rust type used to hold a not-yet-decoded value that has just been received from the database.

impl<'c> HasRow<'c> for MySql

type Database = MySql

type Row = MySqlRow<'c>

The concrete Row implementation for this database.

impl<O, F> MapRow<MySql> for F where
    F: for<'c> FnMut(MySqlRow<'c>) -> O,
    O: Unpin, 

type Output = O

fn map_row(&mut self, row: MySqlRow) -> O

impl<O, F> TryMapRow<MySql> for F where
    F: for<'c> FnMut(MySqlRow<'c>) -> Result<O, Error>,
    O: Unpin, 

type Output = O

fn try_map_row(&mut self, row: MySqlRow) -> Result<O, Error>

impl Type<MySql> for BigDecimal

fn type_info() -> MySqlTypeInfo

Returns the canonical type information on the database for the type T.

impl Type<MySql> for str

fn type_info() -> MySqlTypeInfo

Returns the canonical type information on the database for the type T.

impl Type<MySql> for i16

fn type_info() -> MySqlTypeInfo

Returns the canonical type information on the database for the type T.

impl Type<MySql> for u32

fn type_info() -> MySqlTypeInfo

Returns the canonical type information on the database for the type T.

impl Type<MySql> for Time

fn type_info() -> MySqlTypeInfo

Returns the canonical type information on the database for the type T.

impl Type<MySql> for [u8]

fn type_info() -> MySqlTypeInfo

Returns the canonical type information on the database for the type T.

impl Type<MySql> for Date

fn type_info() -> MySqlTypeInfo

Returns the canonical type information on the database for the type T.

impl Type<MySql> for String

fn type_info() -> MySqlTypeInfo

Returns the canonical type information on the database for the type T.

impl Type<MySql> for u16

fn type_info() -> MySqlTypeInfo

Returns the canonical type information on the database for the type T.

impl Type<MySql> for i8

fn type_info() -> MySqlTypeInfo

Returns the canonical type information on the database for the type T.

impl Type<MySql> for f32

The equivalent MySQL type for f32 is FLOAT.

Note

While we added support for f32 as FLOAT for completeness, we don't recommend using it for any real-life applications as it cannot precisely represent some fractional values, and may be implicitly widened to DOUBLE in some cases, resulting in a slightly different value:

// Widening changes the equivalent decimal value, these two expressions are not equal
// (This is expected behavior for floating points and happens both in Rust and in MySQL)
assert_ne!(10.2f32 as f64, 10.2f64);

fn type_info() -> MySqlTypeInfo

Returns the canonical type information on the database for the type T.

impl Type<MySql> for OffsetDateTime

fn type_info() -> MySqlTypeInfo

Returns the canonical type information on the database for the type T.

impl Type<MySql> for bool

fn type_info() -> MySqlTypeInfo

Returns the canonical type information on the database for the type T.

impl Type<MySql> for u64

fn type_info() -> MySqlTypeInfo

Returns the canonical type information on the database for the type T.

impl Type<MySql> for u8

fn type_info() -> MySqlTypeInfo

Returns the canonical type information on the database for the type T.

impl Type<MySql> for Vec<u8>

fn type_info() -> MySqlTypeInfo

Returns the canonical type information on the database for the type T.

impl Type<MySql> for f64

The equivalent MySQL type for f64 is DOUBLE.

Note that DOUBLE is a floating-point type and cannot represent some fractional values exactly.

fn type_info() -> MySqlTypeInfo

Returns the canonical type information on the database for the type T.

impl Type<MySql> for i32

fn type_info() -> MySqlTypeInfo

Returns the canonical type information on the database for the type T.

impl Type<MySql> for DateTime<Utc>

fn type_info() -> MySqlTypeInfo

Returns the canonical type information on the database for the type T.

impl Type<MySql> for i64

fn type_info() -> MySqlTypeInfo

Returns the canonical type information on the database for the type T.

impl Type<MySql> for PrimitiveDateTime

fn type_info() -> MySqlTypeInfo

Returns the canonical type information on the database for the type T.

impl Type<MySql> for NaiveTime

fn type_info() -> MySqlTypeInfo

Returns the canonical type information on the database for the type T.

impl Type<MySql> for NaiveDate

fn type_info() -> MySqlTypeInfo

Returns the canonical type information on the database for the type T.

impl Type<MySql> for NaiveDateTime

fn type_info() -> MySqlTypeInfo

Returns the canonical type information on the database for the type T.