Struct Mysql 

pub struct Mysql;

MySQL dialect: ? placeholders (positionless), no RETURNING support (that’s a MariaDB 10.5+ extension, not MySQL 8.0), backtick-quoted identifiers, ON DUPLICATE KEY UPDATE ... upserts.

Because MySQL can’t emit the inserted/updated row in-line, the MysqlEngine compensates at the driver layer: inserts look up LAST_INSERT_ID() and SELECT back, updates re-run the WHERE as a SELECT. See prax_mysql::MysqlEngine::execute_insert / execute_update for details.

Trait Implementations

impl SqlDialect for Mysql

fn placeholder(&self, _i: usize) -> String

Emit the 1-indexed parameter placeholder for position i.

fn returning_clause(&self, _cols: &str) -> String

Emit the clause (leading space included) that requests the given columns be returned after an INSERT/UPDATE/DELETE. Postgres/SQLite/MySQL emit RETURNING cols; MSSQL emits OUTPUT INSERTED.cols.

fn insert_has_returning(&self) -> bool

Whether an INSERT statement can use the dialect’s returning clause to retrieve inserted rows in-place.

fn quote_ident(&self, i: &str) -> String

Quote a table/column identifier for safe interpolation.

fn upsert_clause(&self, _c: &[&str], s: &str) -> String

Emit the ON CONFLICT / ON DUPLICATE KEY clause (leading space included) that converts an INSERT into an upsert.

fn supports_distinct_on(&self) -> bool

Whether the dialect supports SELECT DISTINCT ON (cols) (Postgres-only among our backends today).

fn begin_sql(&self) -> &'static str

SQL keyword that begins a transaction. Defaults to BEGIN.

fn commit_sql(&self) -> &'static str

SQL keyword that commits a transaction. Defaults to COMMIT.

fn rollback_sql(&self) -> &'static str

SQL keyword that rolls back a transaction. Defaults to ROLLBACK.