TMySQLDatabase.Methods

Please see TMySQLDatabase methods short descriptions below:

ApplyUpdates

Reserved for future implementation.

ChangeUser

Changes current user and database without re-establishing database connection. MySQL's 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.

GetHostInfo

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

GetIdentifier()

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

GetProtoInfo

Returns the protocol version used by current connection.

GetServerInfo

Returns a server version number string.

GetServerStat

Returns MySQLadmin status info.

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.

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.

StartTransaction

Begins a new transaction against the database server.