Database.MySQL.Simple

Writing queries

The Query type

Parameter substitution

Type inference

Substituting a single parameter

Representing a list of values

Modifying multiple rows at once

Extracting results

Handling null values

Type conversions

Types

data ConnectInfo

data Connection

data Query

data In a

data VaArgs a

data Binary a

data Only a

Exceptions

data FormatError

data QueryError

data ResultError

Connection management

connect

defaultConnectInfo

close

Queries that return results

query

query_

Queries that stream results

fold

fold_

forEach

forEach_

Statements that do not return results

execute

execute_

executeMany

insertID

Transaction handling

withTransaction

autocommit

commit

rollback

Helper functions

formatMany

formatQuery