Module Sql

Description

The SQL module is a unified interface between pike and all its supported databases. The parts of this module that is usuable for all normal uses is the Sql class and the sql_result class.

Example

string people_in_group(string group) {
    Sql.Sql db = Sql.Sql("mysql://localhost/testdb");
    return db->query("SELECT name FROM users WHERE "
                     "group=%s", group)->name * ",";
 }

Constant QUERY_OPTION_CHARSET

constant Sql.QUERY_OPTION_CHARSET

Description

Field to set in the query bindings mapping to set a character set for just the current query. Only supported by some databases.

Variable NULL

Val.Null Sql.NULL

Description

The SQL NULL value.

Deprecated

Replaced by Val.null.

See also

Val.null