DB (gb.mysql)
This class reimplements
DB
in
gb.db.
This class is static.
Inherited constants
|
Blob
|
This constant represents a blob field datatype.
|
|
Boolean
|
Represents a Boolean field datatype.
|
|
Date
|
This constant represents a Date field datatype.
|
|
Float
|
This constant represents a Float field datatype.
|
|
Integer
|
This constant represents an Integer field datatype.
|
|
Long
|
This constant represents a Long field datatype.
|
|
Serial
|
This constant represents a Serial field datatype.
|
|
String
|
This constant represents a String field datatype.
|
Static properties
|
MySQL
|
The goal of gb.mysql is to create MySQL specific routines and then send them to the gb.db to be executed.
|
Inherited static properties
|
Charset
|
Returns the charset used by the database.
|
|
Collations
|
Return the list of collations available in the database
|
|
Current
|
Returns or sets the current connection.
|
|
Databases
|
Returns a collection of all databases managed by the database server.
|
|
Debug
|
Sets or returns if the database component is in debugging mode.
|
|
Error
|
Returns the code of the last error raised by the database driver.
|
|
FullVersion
|
Return the full version of the connected database as a string.
|
|
Handle
|
Return the handle of the connection.
|
|
IgnoreCharset
|
Return or set if the database charset should be ignored.
|
|
LastInsertId
|
Return the value of the last serial field used in an INSERT statement.
|
|
Opened
|
Returns if the connection is opened.
|
|
Tables
|
Returns a virtual collection used for managing the tables of the database.
|
|
Users
|
Returns a collection of all users registered in the database server.
|
|
Version
|
Returns the version of the database that the driver has connected to.
|
Inherited static methods
|
Begin
|
Start a transaction.
|
|
Close
|
Close the connection.
|
|
Commit
|
Commit a transaction.
|
|
Create
|
Return a read/write Result object used for creating records in the specified
table.
|
|
Delete
|
Removes records from a database table.
|
|
Edit
|
Returns a read/write result object used for editing records in the specified
table.
|
|
Exec
|
Executes an arbitrary SQL request, and returns a read-only Result containing
the result of the request.
|
|
Find
|
Returns a read-only Result object used for querying records in the specified
table.
|
|
FormatBlob
|
Format some blob data into a quoted string that can be inserted into a SQL query.
|
|
Limit
|
Limits the number of records returned by the next query.
|
|
Open
|
Opens a connection to the specified database.
|
|
Quote
|
Returns a quoted identifier so that you can freely insert it into a query.
|
|
Rollback
|
Cancel a transaction.
|
|
Subst
|
Creates a SQL sentence by substituting its arguments into a format string.
|