| Extracted from Pike v7.8 release 866 at 2018-02-09.

[Top]
Sql
Sql.mysql

# Method Sql.mysql()->big_query()

Method big_query

  `Mysql.mysql_result big_query(string query, mapping(string|int:mixed)|void bindings, void|string charset)`

Description

  Sends a query to the server.

Parameter `query`

  The SQL query.

Parameter `bindings`

  An optional bindings mapping. See Sql.query for details about this.

Parameter `charset`

  An optional charset that will be used temporarily while sending query to the server. If necessary, a query

  SET character_set_client=charset

is sent to the server first, then query is sent as-is, and then the connection charset is restored again (if necessary).

Primarily useful with charset set to `"latin1"` if unicode encode mode (see set_unicode_encode_mode ) is enabled (the default) and you have some large queries (typically blob inserts) where you want to avoid the query parsing overhead.

Returns

  A Mysql.mysql_result object is returned if the query is of a kind that returns a result. Zero is returned otherwise.

  The individual fields are returned as strings except for `NULL`, which is returned as UNDEFINED .

See also

  Sql.big_query() , big_typed_query() , streaming_query()