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