- exec
ulong exec(Connection conn, const(char[]) sql)
ulong exec(Connection conn, const(char[]) sql, T args)
ulong exec(Connection conn, const(char[]) sql, MySQLVal[] args)
ulong exec(Connection conn, Prepared prepared)
ulong exec(Connection conn, Prepared prepared, T args)
ulong exec(Connection conn, Prepared prepared, MySQLVal[] args)
Execute an SQL command or prepared statement, such as INSERT/UPDATE/CREATE/etc.
- execImpl
ulong execImpl(Connection conn, ExecQueryImplInfo info)
Common implementation for exec overloads
- query
SafeResultRange query(Connection conn, const(char[]) sql, ColumnSpecialization[] csa)
SafeResultRange query(Connection conn, const(char[]) sql, T args)
SafeResultRange query(Connection conn, const(char[]) sql, MySQLVal[] args)
SafeResultRange query(Connection conn, Prepared prepared)
SafeResultRange query(Connection conn, Prepared prepared, T args)
SafeResultRange query(Connection conn, Prepared prepared, MySQLVal[] args)
Execute an SQL SELECT command or prepared statement.
- queryImpl
SafeResultRange queryImpl(ColumnSpecialization[] csa, Connection conn, ExecQueryImplInfo info)
Common implementation for query overloads
- queryRow
Nullable!SafeRow queryRow(Connection conn, const(char[]) sql, ColumnSpecialization[] csa)
Nullable!SafeRow queryRow(Connection conn, const(char[]) sql, T args)
Nullable!SafeRow queryRow(Connection conn, const(char[]) sql, MySQLVal[] args)
Nullable!SafeRow queryRow(Connection conn, Prepared prepared)
Nullable!SafeRow queryRow(Connection conn, Prepared prepared, T args)
Nullable!SafeRow queryRow(Connection conn, Prepared prepared, MySQLVal[] args)
Execute an SQL SELECT command or prepared statement where you only want the
first mysql.impl.result.SafeRow, if any.
- queryRowImpl
Nullable!SafeRow queryRowImpl(ColumnSpecialization[] csa, Connection conn, ExecQueryImplInfo info)
Common implementation for querySet overloads.
- queryRowTuple
void queryRowTuple(Connection conn, const(char[]) sql, T args)
void queryRowTuple(Connection conn, Prepared prepared, T args)
Execute an SQL SELECT command or prepared statement where you only want the
first mysql.result.Row, and place result values into a set of D variables.
- queryRowTupleImpl
void queryRowTupleImpl(Connection conn, ExecQueryImplInfo info, T args)
Common implementation for queryRowTuple overloads.
- queryValue
Nullable!MySQLVal queryValue(Connection conn, const(char[]) sql, ColumnSpecialization[] csa)
Nullable!MySQLVal queryValue(Connection conn, const(char[]) sql, T args)
Nullable!MySQLVal queryValue(Connection conn, const(char[]) sql, MySQLVal[] args)
Nullable!MySQLVal queryValue(Connection conn, Prepared prepared)
Nullable!MySQLVal queryValue(Connection conn, Prepared prepared, T args)
Nullable!MySQLVal queryValue(Connection conn, Prepared prepared, MySQLVal[] args)
Execute an SQL SELECT command or prepared statement and return a single value:
the first column of the first row received.
- queryValueImpl
Nullable!MySQLVal queryValueImpl(ColumnSpecialization[] csa, Connection conn, ExecQueryImplInfo info)
Common implementation for queryValue overloads.
Use a DB via plain SQL statements (safe version).
Commands that are expected to return a result set - queries - have distinctive methods that are enforced. That is it will be an error to call such a method with an SQL command that does not produce a result set. So for commands like SELECT, use the query functions. For other commands, like INSERT/UPDATE/CREATE/etc, use exec.
This is the @safe version of mysql's command module, and as such uses the @safe rows and result ranges, and the MySQLVal type. For the Variant unsafe version, please import mysql.unsafe.commands.
$(SAFE_MIGRATION)