Struct MySQLDialect 

pub struct MySQLDialect;

Type-level marker for MySQL.

Selects MySQL type mappings (DialectTypes, SQLTypeToRust). MySQL keeps signed and unsigned integer types apart, quotes identifiers with backticks, and has one native JSON type. It has no native UUID or time-zone-aware datetime: UUIDs use BINARY(16), and TimestampTz maps to TIMESTAMP, which follows the session time zone.

Trait Implementations

impl AggregatePolicy<MySQLDialect> for TinyInt

type Sum = Decimal

Result type of SUM.

type Avg = Decimal

Result type of AVG.

impl AggregatePolicy<MySQLDialect> for TinyIntUnsigned

type Sum = Decimal

Result type of SUM.

type Avg = Decimal

Result type of AVG.

impl AggregatePolicy<MySQLDialect> for SmallInt

type Sum = Decimal

Result type of SUM.

type Avg = Decimal

Result type of AVG.

impl AggregatePolicy<MySQLDialect> for SmallIntUnsigned

type Sum = Decimal

Result type of SUM.

type Avg = Decimal

Result type of AVG.

impl AggregatePolicy<MySQLDialect> for MediumInt

type Sum = Decimal

Result type of SUM.

type Avg = Decimal

Result type of AVG.

impl AggregatePolicy<MySQLDialect> for MediumIntUnsigned

type Sum = Decimal

Result type of SUM.

type Avg = Decimal

Result type of AVG.

impl AggregatePolicy<MySQLDialect> for Int

type Sum = Decimal

Result type of SUM.

type Avg = Decimal

Result type of AVG.

impl AggregatePolicy<MySQLDialect> for IntUnsigned

type Sum = Decimal

Result type of SUM.

type Avg = Decimal

Result type of AVG.

impl AggregatePolicy<MySQLDialect> for BigInt

type Sum = Decimal

Result type of SUM.

type Avg = Decimal

Result type of AVG.

impl AggregatePolicy<MySQLDialect> for BigIntUnsigned

type Sum = Decimal

Result type of SUM.

type Avg = Decimal

Result type of AVG.

impl AggregatePolicy<MySQLDialect> for Year

type Sum = Decimal

Result type of SUM.

type Avg = Decimal

Result type of AVG.

impl AggregatePolicy<MySQLDialect> for Decimal

type Sum = Decimal

Result type of SUM.

type Avg = Decimal

Result type of AVG.

impl AggregatePolicy<MySQLDialect> for Float

type Sum = Double

Result type of SUM.

type Avg = Double

Result type of AVG.

impl AggregatePolicy<MySQLDialect> for Double

type Sum = Double

Result type of SUM.

type Avg = Double

Result type of AVG.

impl<Source: DataType> CastTypePolicy<MySQLDialect, Source, BigInt> for ()

impl<Source: DataType> CastTypePolicy<MySQLDialect, Source, BigIntUnsigned> for ()

impl<Source: DataType> CastTypePolicy<MySQLDialect, Source, Date> for ()

impl<Source: DataType> CastTypePolicy<MySQLDialect, Source, DateTime> for ()

impl<Source: DataType> CastTypePolicy<MySQLDialect, Source, Decimal> for ()

impl<Source: DataType> CastTypePolicy<MySQLDialect, Source, Double> for ()

impl<Source: DataType> CastTypePolicy<MySQLDialect, Source, Float> for ()

impl<Source: DataType> CastTypePolicy<MySQLDialect, Source, Json> for ()

impl<Source: DataType> CastTypePolicy<MySQLDialect, Source, Time> for ()

impl<Source: DataType> CastTypePolicy<MySQLDialect, Source, Varbinary> for ()

impl<Source: DataType> CastTypePolicy<MySQLDialect, Source, Varchar> for ()

impl<Source: DataType> CastTypePolicy<MySQLDialect, Source, Year> for ()

impl Clone for MySQLDialect

fn clone(&self) -> Self

Returns a duplicate of the value.

fn clone_from(&mut self, source: &Self)

Performs copy-assignment from source.

impl Copy for MySQLDialect

impl Debug for MySQLDialect

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

Formats the value using the given formatter.

impl DialectSupports<GroupConcat> for MySQLDialect

impl DialectSupports<LeftRight> for MySQLDialect

impl DialectSupports<Pad> for MySQLDialect

impl DialectSupports<Repeat> for MySQLDialect

impl DialectSupports<Reverse> for MySQLDialect

impl DialectTypes for MySQLDialect

const CHAR_LENGTH_FN: &'static str = "CHAR_LENGTH"

Name of the character-count function (LENGTH on SQLite).

type SmallInt = SmallInt

16-bit integer.

type Int = Int

32-bit integer.

type BigInt = BigInt

64-bit integer.

type Float = Float

Single-precision float.

type Double = Double

Double-precision float.

type Text = Text

Text.

type Bool = Boolean

Boolean (an integer on SQLite).

type Bytes = Blob

Binary data.

type Date = Date

Calendar date.

type Time = Time

Time of day.

type Timestamp = DateTime

Date and time without a time zone.

type TimestampTz = Timestamp

Date and time with a time zone.

type Uuid = Binary

UUID.

type Json = Json

JSON.

type Jsonb = Json

Binary JSON (jsonb; plain JSON where the dialect has no jsonb).

type Any = Any

A value of unknown type.

type Random = Double

Result type of RANDOM().

type Sign = BigInt

Result type of SIGN(x).

type DomainNullable<Input: Nullability> = Null

Nullability of a math function whose domain is narrower than its input type (SQRT, LN, LOG, …) given input nullability Input: SQLite and MySQL answer NULL outside the domain, PostgreSQL raises.

impl<L, R> GreatestLeastPolicy<L, R> for MySQLDialect

where L: Nullability, R: Nullability,

type Nullable = <L as Nullability>::Or<R>

Nullability of the result.

type Sources<A, B> = (A, B)

How the operands’ sources (each an Arg) combine.

impl InstrPolicy for MySQLDialect

type Output = BigInt

Result type of INSTR.

impl LengthPolicy<MySQLDialect> for Char

type Output = BigInt

Result type of the length functions.

impl LengthPolicy<MySQLDialect> for Varchar

type Output = BigInt

Result type of the length functions.

impl LengthPolicy<MySQLDialect> for TinyText

type Output = BigInt

Result type of the length functions.

impl LengthPolicy<MySQLDialect> for Text

type Output = BigInt

Result type of the length functions.

impl LengthPolicy<MySQLDialect> for MediumText

type Output = BigInt

Result type of the length functions.

impl LengthPolicy<MySQLDialect> for LongText

type Output = BigInt

Result type of the length functions.

impl LengthPolicy<MySQLDialect> for Enum

type Output = BigInt

Result type of the length functions.

impl LengthPolicy<MySQLDialect> for Set

type Output = BigInt

Result type of the length functions.

impl Log2Policy for MySQLDialect

type Nullable = Null

Nullability of the LOG2 result.

impl MathExt for MySQLDialect

impl RoundingPolicy<MySQLDialect> for TinyInt

type Output = BigInt

Result type of the rounding functions.

fn precision_operand<'a, V: SQLParam + 'a>(expr: SQL<'a, V>) -> SQL<'a, V>

Prepares the operand of ROUND(expr, precision).

fn coerce_result<'a, V: SQLParam + 'a>(sql: SQL<'a, V>) -> SQL<'a, V>

Coerces a rounding function’s result to Self::Output.

impl RoundingPolicy<MySQLDialect> for SmallInt

type Output = BigInt

Result type of the rounding functions.

fn precision_operand<'a, V: SQLParam + 'a>(expr: SQL<'a, V>) -> SQL<'a, V>

Prepares the operand of ROUND(expr, precision).

fn coerce_result<'a, V: SQLParam + 'a>(sql: SQL<'a, V>) -> SQL<'a, V>

Coerces a rounding function’s result to Self::Output.

impl RoundingPolicy<MySQLDialect> for MediumInt

type Output = BigInt

Result type of the rounding functions.

fn precision_operand<'a, V: SQLParam + 'a>(expr: SQL<'a, V>) -> SQL<'a, V>

Prepares the operand of ROUND(expr, precision).

fn coerce_result<'a, V: SQLParam + 'a>(sql: SQL<'a, V>) -> SQL<'a, V>

Coerces a rounding function’s result to Self::Output.

impl RoundingPolicy<MySQLDialect> for Int

type Output = BigInt

Result type of the rounding functions.

fn precision_operand<'a, V: SQLParam + 'a>(expr: SQL<'a, V>) -> SQL<'a, V>

Prepares the operand of ROUND(expr, precision).

fn coerce_result<'a, V: SQLParam + 'a>(sql: SQL<'a, V>) -> SQL<'a, V>

Coerces a rounding function’s result to Self::Output.

impl RoundingPolicy<MySQLDialect> for BigInt

type Output = BigInt

Result type of the rounding functions.

fn precision_operand<'a, V: SQLParam + 'a>(expr: SQL<'a, V>) -> SQL<'a, V>

Prepares the operand of ROUND(expr, precision).

fn coerce_result<'a, V: SQLParam + 'a>(sql: SQL<'a, V>) -> SQL<'a, V>

Coerces a rounding function’s result to Self::Output.

impl RoundingPolicy<MySQLDialect> for TinyIntUnsigned

type Output = BigIntUnsigned

Result type of the rounding functions.

fn precision_operand<'a, V: SQLParam + 'a>(expr: SQL<'a, V>) -> SQL<'a, V>

Prepares the operand of ROUND(expr, precision).

fn coerce_result<'a, V: SQLParam + 'a>(sql: SQL<'a, V>) -> SQL<'a, V>

Coerces a rounding function’s result to Self::Output.

impl RoundingPolicy<MySQLDialect> for SmallIntUnsigned

type Output = BigIntUnsigned

Result type of the rounding functions.

fn precision_operand<'a, V: SQLParam + 'a>(expr: SQL<'a, V>) -> SQL<'a, V>

Prepares the operand of ROUND(expr, precision).

fn coerce_result<'a, V: SQLParam + 'a>(sql: SQL<'a, V>) -> SQL<'a, V>

Coerces a rounding function’s result to Self::Output.

impl RoundingPolicy<MySQLDialect> for MediumIntUnsigned

type Output = BigIntUnsigned

Result type of the rounding functions.

fn precision_operand<'a, V: SQLParam + 'a>(expr: SQL<'a, V>) -> SQL<'a, V>

Prepares the operand of ROUND(expr, precision).

fn coerce_result<'a, V: SQLParam + 'a>(sql: SQL<'a, V>) -> SQL<'a, V>

Coerces a rounding function’s result to Self::Output.

impl RoundingPolicy<MySQLDialect> for IntUnsigned

type Output = BigIntUnsigned

Result type of the rounding functions.

fn precision_operand<'a, V: SQLParam + 'a>(expr: SQL<'a, V>) -> SQL<'a, V>

Prepares the operand of ROUND(expr, precision).

fn coerce_result<'a, V: SQLParam + 'a>(sql: SQL<'a, V>) -> SQL<'a, V>

Coerces a rounding function’s result to Self::Output.

impl RoundingPolicy<MySQLDialect> for BigIntUnsigned

type Output = BigIntUnsigned

Result type of the rounding functions.

fn precision_operand<'a, V: SQLParam + 'a>(expr: SQL<'a, V>) -> SQL<'a, V>

Prepares the operand of ROUND(expr, precision).

fn coerce_result<'a, V: SQLParam + 'a>(sql: SQL<'a, V>) -> SQL<'a, V>

Coerces a rounding function’s result to Self::Output.

impl RoundingPolicy<MySQLDialect> for Year

type Output = BigIntUnsigned

Result type of the rounding functions.

fn precision_operand<'a, V: SQLParam + 'a>(expr: SQL<'a, V>) -> SQL<'a, V>

Prepares the operand of ROUND(expr, precision).

fn coerce_result<'a, V: SQLParam + 'a>(sql: SQL<'a, V>) -> SQL<'a, V>

Coerces a rounding function’s result to Self::Output.

impl RoundingPolicy<MySQLDialect> for Float

type Output = Double

Result type of the rounding functions.

fn precision_operand<'a, V: SQLParam + 'a>(expr: SQL<'a, V>) -> SQL<'a, V>

Prepares the operand of ROUND(expr, precision).

fn coerce_result<'a, V: SQLParam + 'a>(sql: SQL<'a, V>) -> SQL<'a, V>

Coerces a rounding function’s result to Self::Output.

impl RoundingPolicy<MySQLDialect> for Double

type Output = Double

Result type of the rounding functions.

fn precision_operand<'a, V: SQLParam + 'a>(expr: SQL<'a, V>) -> SQL<'a, V>

Prepares the operand of ROUND(expr, precision).

fn coerce_result<'a, V: SQLParam + 'a>(sql: SQL<'a, V>) -> SQL<'a, V>

Coerces a rounding function’s result to Self::Output.

impl RoundingPolicy<MySQLDialect> for Decimal

type Output = Decimal

Result type of the rounding functions.

fn precision_operand<'a, V: SQLParam + 'a>(expr: SQL<'a, V>) -> SQL<'a, V>

Prepares the operand of ROUND(expr, precision).

fn coerce_result<'a, V: SQLParam + 'a>(sql: SQL<'a, V>) -> SQL<'a, V>

Coerces a rounding function’s result to Self::Output.

impl SQLTypeToRust<MySQLDialect> for TinyInt

type RustType = i8

impl SQLTypeToRust<MySQLDialect> for TinyIntUnsigned

type RustType = u8

impl SQLTypeToRust<MySQLDialect> for SmallInt

type RustType = i16

impl SQLTypeToRust<MySQLDialect> for SmallIntUnsigned

type RustType = u16

impl SQLTypeToRust<MySQLDialect> for MediumInt

type RustType = i32

impl SQLTypeToRust<MySQLDialect> for Int

type RustType = i32

impl SQLTypeToRust<MySQLDialect> for MediumIntUnsigned

type RustType = u32

impl SQLTypeToRust<MySQLDialect> for IntUnsigned

type RustType = u32

impl SQLTypeToRust<MySQLDialect> for BigInt

type RustType = i64

impl SQLTypeToRust<MySQLDialect> for BigIntUnsigned

type RustType = u64

impl SQLTypeToRust<MySQLDialect> for Float

type RustType = f32

impl SQLTypeToRust<MySQLDialect> for Double

type RustType = f64

impl SQLTypeToRust<MySQLDialect> for Boolean

type RustType = bool

impl SQLTypeToRust<MySQLDialect> for Char

type RustType = String

impl SQLTypeToRust<MySQLDialect> for Varchar

type RustType = String

impl SQLTypeToRust<MySQLDialect> for TinyText

type RustType = String

impl SQLTypeToRust<MySQLDialect> for Text

type RustType = String

impl SQLTypeToRust<MySQLDialect> for MediumText

type RustType = String

impl SQLTypeToRust<MySQLDialect> for LongText

type RustType = String

impl SQLTypeToRust<MySQLDialect> for Enum

type RustType = String

impl SQLTypeToRust<MySQLDialect> for Set

type RustType = String

impl SQLTypeToRust<MySQLDialect> for Any

type RustType = String

impl SQLTypeToRust<MySQLDialect> for Binary

type RustType = Vec<u8>

impl SQLTypeToRust<MySQLDialect> for Varbinary

type RustType = Vec<u8>

impl SQLTypeToRust<MySQLDialect> for TinyBlob

type RustType = Vec<u8>

impl SQLTypeToRust<MySQLDialect> for Blob

type RustType = Vec<u8>

impl SQLTypeToRust<MySQLDialect> for MediumBlob

type RustType = Vec<u8>

impl SQLTypeToRust<MySQLDialect> for LongBlob

type RustType = Vec<u8>

impl SQLTypeToRust<MySQLDialect> for Bit

type RustType = Vec<u8>

impl SQLTypeToRust<MySQLDialect> for Year

type RustType = u16

impl SQLTypeToRust<MySQLDialect> for Decimal

type RustType = String

impl SQLTypeToRust<MySQLDialect> for Json

type RustType = String

impl SQLTypeToRust<MySQLDialect> for Date

type RustType = String

impl SQLTypeToRust<MySQLDialect> for Time

type RustType = String

impl SQLTypeToRust<MySQLDialect> for DateTime

type RustType = String

impl SQLTypeToRust<MySQLDialect> for Timestamp

type RustType = String

impl StatisticalAggregatePolicy<MySQLDialect> for TinyInt

type StddevPop = Double

Result type of STDDEV_POP.

type StddevSamp = Double

Result type of STDDEV_SAMP.

type VarPop = Double

Result type of VAR_POP.

type VarSamp = Double

Result type of VAR_SAMP / VARIANCE.

impl StatisticalAggregatePolicy<MySQLDialect> for TinyIntUnsigned

type StddevPop = Double

Result type of STDDEV_POP.

type StddevSamp = Double

Result type of STDDEV_SAMP.

type VarPop = Double

Result type of VAR_POP.

type VarSamp = Double

Result type of VAR_SAMP / VARIANCE.

impl StatisticalAggregatePolicy<MySQLDialect> for SmallInt

type StddevPop = Double

Result type of STDDEV_POP.

type StddevSamp = Double

Result type of STDDEV_SAMP.

type VarPop = Double

Result type of VAR_POP.

type VarSamp = Double

Result type of VAR_SAMP / VARIANCE.

impl StatisticalAggregatePolicy<MySQLDialect> for SmallIntUnsigned

type StddevPop = Double

Result type of STDDEV_POP.

type StddevSamp = Double

Result type of STDDEV_SAMP.

type VarPop = Double

Result type of VAR_POP.

type VarSamp = Double

Result type of VAR_SAMP / VARIANCE.

impl StatisticalAggregatePolicy<MySQLDialect> for MediumInt

type StddevPop = Double

Result type of STDDEV_POP.

type StddevSamp = Double

Result type of STDDEV_SAMP.

type VarPop = Double

Result type of VAR_POP.

type VarSamp = Double

Result type of VAR_SAMP / VARIANCE.

impl StatisticalAggregatePolicy<MySQLDialect> for MediumIntUnsigned

type StddevPop = Double

Result type of STDDEV_POP.

type StddevSamp = Double

Result type of STDDEV_SAMP.

type VarPop = Double

Result type of VAR_POP.

type VarSamp = Double

Result type of VAR_SAMP / VARIANCE.

impl StatisticalAggregatePolicy<MySQLDialect> for Int

type StddevPop = Double

Result type of STDDEV_POP.

type StddevSamp = Double

Result type of STDDEV_SAMP.

type VarPop = Double

Result type of VAR_POP.

type VarSamp = Double

Result type of VAR_SAMP / VARIANCE.

impl StatisticalAggregatePolicy<MySQLDialect> for IntUnsigned

type StddevPop = Double

Result type of STDDEV_POP.

type StddevSamp = Double

Result type of STDDEV_SAMP.

type VarPop = Double

Result type of VAR_POP.

type VarSamp = Double

Result type of VAR_SAMP / VARIANCE.

impl StatisticalAggregatePolicy<MySQLDialect> for BigInt

type StddevPop = Double

Result type of STDDEV_POP.

type StddevSamp = Double

Result type of STDDEV_SAMP.

type VarPop = Double

Result type of VAR_POP.

type VarSamp = Double

Result type of VAR_SAMP / VARIANCE.

impl StatisticalAggregatePolicy<MySQLDialect> for BigIntUnsigned

type StddevPop = Double

Result type of STDDEV_POP.

type StddevSamp = Double

Result type of STDDEV_SAMP.

type VarPop = Double

Result type of VAR_POP.

type VarSamp = Double

Result type of VAR_SAMP / VARIANCE.

impl StatisticalAggregatePolicy<MySQLDialect> for Year

type StddevPop = Double

Result type of STDDEV_POP.

type StddevSamp = Double

Result type of STDDEV_SAMP.

type VarPop = Double

Result type of VAR_POP.

type VarSamp = Double

Result type of VAR_SAMP / VARIANCE.

impl StatisticalAggregatePolicy<MySQLDialect> for Decimal

type StddevPop = Double

Result type of STDDEV_POP.

type StddevSamp = Double

Result type of STDDEV_SAMP.

type VarPop = Double

Result type of VAR_POP.

type VarSamp = Double

Result type of VAR_SAMP / VARIANCE.

impl StatisticalAggregatePolicy<MySQLDialect> for Float

type StddevPop = Double

Result type of STDDEV_POP.

type StddevSamp = Double

Result type of STDDEV_SAMP.

type VarPop = Double

Result type of VAR_POP.

type VarSamp = Double

Result type of VAR_SAMP / VARIANCE.

impl StatisticalAggregatePolicy<MySQLDialect> for Double

type StddevPop = Double

Result type of STDDEV_POP.

type StddevSamp = Double

Result type of STDDEV_SAMP.

type VarPop = Double

Result type of VAR_POP.

type VarSamp = Double

Result type of VAR_SAMP / VARIANCE.

impl ValueTypeForDialect<MySQLDialect> for i8

type SQLType = TinyInt

The SQL type marker.

impl ValueTypeForDialect<MySQLDialect> for i16

type SQLType = SmallInt

The SQL type marker.

impl ValueTypeForDialect<MySQLDialect> for i32

type SQLType = Int

The SQL type marker.

impl ValueTypeForDialect<MySQLDialect> for i64

type SQLType = BigInt

The SQL type marker.

impl ValueTypeForDialect<MySQLDialect> for isize

type SQLType = BigInt

The SQL type marker.

impl ValueTypeForDialect<MySQLDialect> for u8

type SQLType = TinyIntUnsigned

The SQL type marker.

impl ValueTypeForDialect<MySQLDialect> for u16

type SQLType = SmallIntUnsigned

The SQL type marker.

impl ValueTypeForDialect<MySQLDialect> for u32

type SQLType = IntUnsigned

The SQL type marker.

impl ValueTypeForDialect<MySQLDialect> for u64

type SQLType = BigIntUnsigned

The SQL type marker.

impl ValueTypeForDialect<MySQLDialect> for usize

type SQLType = BigIntUnsigned

The SQL type marker.

impl ValueTypeForDialect<MySQLDialect> for f32

type SQLType = Float

The SQL type marker.

impl ValueTypeForDialect<MySQLDialect> for f64

type SQLType = Double

The SQL type marker.

impl ValueTypeForDialect<MySQLDialect> for bool

type SQLType = Boolean

The SQL type marker.

impl ValueTypeForDialect<MySQLDialect> for &str

type SQLType = Text

The SQL type marker.

impl ValueTypeForDialect<MySQLDialect> for Cow<'_, str>

type SQLType = Text

The SQL type marker.

impl ValueTypeForDialect<MySQLDialect> for String

type SQLType = Text

The SQL type marker.

impl ValueTypeForDialect<MySQLDialect> for Box<String>

type SQLType = Text

The SQL type marker.

impl ValueTypeForDialect<MySQLDialect> for Rc<String>

type SQLType = Text

The SQL type marker.

impl ValueTypeForDialect<MySQLDialect> for Arc<String>

type SQLType = Text

The SQL type marker.

impl ValueTypeForDialect<MySQLDialect> for Box<str>

type SQLType = Text

The SQL type marker.

impl ValueTypeForDialect<MySQLDialect> for Rc<str>

type SQLType = Text

The SQL type marker.

impl ValueTypeForDialect<MySQLDialect> for Arc<str>

type SQLType = Text

The SQL type marker.

impl ValueTypeForDialect<MySQLDialect> for &[u8]

type SQLType = Blob

The SQL type marker.

impl ValueTypeForDialect<MySQLDialect> for Cow<'_, [u8]>

type SQLType = Blob

The SQL type marker.

impl ValueTypeForDialect<MySQLDialect> for Vec<u8>

type SQLType = Blob

The SQL type marker.

impl ValueTypeForDialect<MySQLDialect> for Box<Vec<u8>>

type SQLType = Blob

The SQL type marker.

impl ValueTypeForDialect<MySQLDialect> for Rc<Vec<u8>>

type SQLType = Blob

The SQL type marker.

impl ValueTypeForDialect<MySQLDialect> for Arc<Vec<u8>>

type SQLType = Blob

The SQL type marker.

impl<const N: usize> ValueTypeForDialect<MySQLDialect> for [u8; N]

type SQLType = Binary

The SQL type marker.

impl<const N: usize> ValueTypeForDialect<MySQLDialect> for [char; N]

type SQLType = Char

The SQL type marker.