| Extracted from Pike v7.8 release 866 at 2016-04-05.

[Top]
Sql
Sql.Sql

# Method Sql.Sql()->big_typed_query()

Method big_typed_query

  `int|object big_typed_query(object|string q, mixed ... extraargs)`

Description

  Sends an SQL query synchronously to the underlying SQL-server and returns the results in typed mode.

  For the arguments, please see the query() function.

  The result is returned as an Sql.sql_result object in typed mode. This allows for having some more info about the result as well as processing the result in a streaming fashion, although the result itself wasn't obtained streamingly from the server. Returns `0` if the query didn't return any result (e.g. `INSERT` or similar).

Note

  Typed mode is not supported by all sql databases. If not supported, an error is thrown.

Note

  Despite the name, this function is not only useful for "big" queries. It typically has less overhead than typed_query also for ones that return only a few rows.

See also

  query , typed_query , big_query , streaming_query