EPUB | CHM | PDF

TMySQLDatabase.Methods

Top Previous Next

Please see TMySQLDatabase methods short descriptions below:

ApplyUpdates

Reserved for future implementation.

ChangeUser

Changes current user and database without re-establishing database connection. MySQL library mysql_change_user function analog.

Close

Closes the connection.

CloseDataSets

Closes all datasets associated with the database component without disconnecting from the database server.

Commit

Permanently stores updates, insertions, and deletions of data associated with the current transaction, and ends the current transactions.

Connect

Connects TMySQLDatabase to MySQL database.

ConnectWithConnectionOptionsDialog

Connects TMySQLDatabase to MySQL database with "MySQL connection options" dialog.

Create

Creates an instance of a TMySQLDataBase component.

Destroy

Destroys the instance of a database component.

Disconnect

Closes connection with database.

Execute

Executes an SQL statement.

GetCharSet

Returns database's code page.

GetClientInfo

Returns a string that represents the client library version.

GetDatabaseCharacterset

Returns character set name string for current database.

GetDatabaseCollation

Returns collation name string for current database.

GetDatabases

Populates a stringlist with the names of persistent MySQL databases.

GetDatabaseSize

Return the current database size in bytes.

GetFieldNames

Populates a string list with the names of fields in a table.

GetFuncNames (deprecated)

Returns list of functions available at the moment in the current database.

GetHostInfo

Returns a string describing the type of connection in use. Deprecated method.

GetIdentifier

Returns quoted identifier if server supports backquote character (`).

GetProtoInfo

Returns the protocol version used by current connection.

GetRoutinesNames

Returns list of routines available at the moment in the current database.

GetServerInfo

Returns a server version number string.

GetServerStat

Returns MySQLadmin status info.

GetStoredProcNames (deprecated)

Returns list of stored procedures available at the moment in the current database.

GeTableEngines

Populates a string list with the Engine type of the tables.

GetTableNames

Populates a string list with the names of tables associated with a specified database component.

Kill

Kills a thread.

Open

Opens the connection.

Ping

Pings MySQL server.

Reconnect

Resets the communication channel to the server.

Rollback

Cancels all updates, insertions, and deletions for the current transaction and ends the transaction.

SelectXXX

Methods of this group execute SQL Query and return result as single value casted to XXX type.

Shutdown

Stops MySQL server.

StartTransaction

Begins a new transaction against the database server.