mysql-native v3.0.0

API Reference Home: [This Version] [Latest Version] [Other Versions]


Module mysql.commands

Use a DB via plain SQL statements.

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.

Functions

NameDescription
exec(conn, sql) Execute an SQL command or prepared statement, such as INSERT/UPDATE/CREATE/etc.
query(conn, sql, csa) Execute an SQL SELECT command or prepared statement.
queryRow(conn, sql, csa) Execute an SQL SELECT command or prepared statement where you only want the first Row, if any.
queryRowTuple(conn, sql, args) Execute an SQL SELECT command or prepared statement where you only want the first Row, and place result values into a set of D variables.
queryValue(conn, sql, csa) Execute an SQL SELECT command or prepared statement and return a single value: the first column of the first row received.

Structs

NameDescription
ColumnSpecialization This feature is not yet implemented. It currently has no effect.

Aliases

NameTypeDescription
CSN ColumnSpecialization This feature is not yet implemented. It currently has no effect.