Pike v8.1 release 6

Method Sql.mysql()->big_query()


Method big_query

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 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()