| Extracted from Pike v7.8 release 700 at 2013-06-08.

[Top]
Sql
Sql.Sql

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

Method create

  `void Sql.Sql(string host)`
  `void Sql.Sql(string host, string db)`
  `void Sql.Sql(string host, mapping(string:int|string) options)`
  `void Sql.Sql(string host, string db, string user)`
  `void Sql.Sql(string host, string db, string user, string password)`
  `void Sql.Sql(string host, string db, string user, string password, mapping(string:int|string) options)`
  `void Sql.Sql(object host)`
  `void Sql.Sql(object host, string db)`

Description

  Create a new generic SQL object.

Parameter `host`

  `object` | Use this object to access the SQL-database.

  `string`

  Connect to the server specified. The string should be on the format: `dbtype://[user[:password]@]hostname[:port][/database]` Use the dbtype protocol to connect to the database server on the specified host. If the hostname is `""` then the port can be a file name to access through a UNIX-domain socket or similar, e g `"mysql://root@:/tmp/mysql.sock/"`.

  There is a special dbtype `"mysqls"` which works like `"mysql"` but sets the `CLIENT_SSL` option and loads the `/etc/my.cnf` config file to find the SSL parameters. The same function can be achieved using the `"mysql"` dbtype.

  `int(0..0)` | Access through a UNIX-domain socket or similar.

Parameter `db`

  Select this database.

Parameter `user`

  User name to access the database as.

Parameter `password`

  Password to access the database.

Parameter `options`

  Optional mapping of options. See the SQL-database documentation for the supported options. (eg Mysql.mysql()->create() ).

Note

  In versions of Pike prior to 7.2 it was possible to leave out the dbtype, but that has been deprecated, since it never worked well.

Note

  Support for options was added in Pike 7.3.