Method Sql.mysql()->big_query()


Method big_query

variant Result big_query(string query, mapping(string|int:mixed)|void bindings, void|__deprecated__(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. The mapping may contain a QUERY_OPTION_CHARSET entry with the same semantics as the deprecated charset parameter below.

Parameter charset

DEPRECATED 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.

Deprecated; use the entry QUERY_OPTION_CHARSET in bindings instead.

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