MySQLConn wrap both InputStream and OutputStream for MySQL Packet.

You shouldn't use one MySQLConn in different thread, if you do that, consider protecting it with a MVar.

Everything you need to establish a MySQL connection.

To setup a TLS connection, use module Database.MySQL.TLS or Database.MySQL.OpenSSL.

A simple ConnectInfo targeting localhost with user=root and empty password.

Default charset is set to utf8_general_ci to support older(< 5.5.3) MySQL versions, but be aware this is a partial utf8 encoding, you may want to use defaultConnectInfoMB4 instead to support full utf8 charset(emoji, etc.). You can query your server's support with SELECT id, collation_name FROM information_schema.collations ORDER BY id;

defaultConnectInfo with charset set to utf8mb4_unicode_ci

This is recommanded on any MySQL server version >= 5.5.3.

Establish a MySQL connection.

Establish a MySQL connection with Greeting back, so you can find server's version .etc.

Close a MySQL connection.

Send a COM_PING.

Execute a MySQL query with parameters which don't return a result-set.

The query may contain placeholders ?, for filling up parameters, the parameters will be escaped before get filled into the query, please DO NOT enable NO_BACKSLASH_ESCAPES, and you should consider using prepared statement if this's not an one shot query.

Execute a multi-row query which don't return result-set.

Leverage MySQL's multi-statement support to do batch insert/update/delete, you may want to use withTransaction to make sure it's atomic, and use sum . map okAffectedRows to get all affected rows count.

Since: 0.2.0.0

Execute multiple querys (without param) which don't return result-set.

This's useful when your want to execute multiple SQLs without params, e.g. from a SQL dump, or a table migration plan.

Since: 0.8.4.0

Execute a MySQL query which don't return a result-set.

Execute a MySQL query which return a result-set.

Vector version of query_.

Since: 0.5.1.0

Execute a MySQL query which return a result-set with parameters.

Note that you must fully consumed the result-set before start a new query on the same MySQLConn, or an UnconsumedResultSet will be thrown. if you want to skip the result-set, use skipToEof.

Vector version of query.

Since: 0.5.1.0

Ask MySQL to prepare a query statement.

Ask MySQL to prepare a query statement.

All details from COM_STMT_PREPARE Response are returned: the StmtPrepareOK packet, params's ColumnDef, result's ColumnDef.

Execute prepared query statement with parameters, expecting no resultset.

Execute prepared query statement with parameters, expecting resultset.

Rules about UnconsumedResultSet applied here too.

Vector version of queryStmt

Since: 0.5.1.0

Ask MySQL to closed a query statement.

Ask MySQL to reset a query statement, all previous resultset will be cleared.

Run querys inside a transaction, querys will be rolled back if exception arise.

Since: 0.2.0.0

A type that may be used as a single parameter to a SQL query. Inspired from mysql-simple.

A type to wrap a query parameter in to allow for single and multi-valued parameters.

The behavior of Param can be illustrated by following example:

   render $ One (MySQLText "hello") = hello
   render $ Many [MySQLText "hello", MySQLText "world"] = hello, world
   render $ Many [] = null

So you can now write a query like this: SELECT * FROM test WHERE _id IN (?, 888) and use Many Param to fill the hole. There's no equivalent for prepared statement sadly.

Query string type borrowed from mysql-simple.

This type is intended to make it difficult to construct a SQL query by concatenating string fragments, as that is an extremely common way to accidentally introduce SQL injection vulnerabilities into an application.

This type is an instance of IsString, so the easiest way to construct a query is to enable the OverloadedStrings language extension and then simply write the query in double quotes.

The underlying type is a ByteString, and literal Haskell strings that contain Unicode characters will be correctly transformed to UTF-8.

Send a Command which don't return a resultSet.

Drives an InputStream to end-of-stream, discarding all of the yielded values.