Please see TMySQLDatabase methods short descriptions below:
Reserved for future implementation.
Changes current user and database without re-establishing database connection. MySQL library mysql_change_user function analog.
Closes the connection.
Closes all datasets associated with the database component without disconnecting from the database server.
Permanently stores updates, insertions, and deletions of data associated with the current transaction, and ends the current transactions.
Connects TMySQLDatabase to MySQL database.
ConnectWithConnectionOptionsDialog
Connects TMySQLDatabase to MySQL database with "MySQL connection options" dialog.
Creates an instance of a TMySQLDataBase component.
Destroys the instance of a database component.
Closes connection with database.
Executes an SQL statement.
Returns database's code page.
Returns a string that represents the client library version.
Returns character set name string for current database.
Returns collation name string for current database.
Populates a stringlist with the names of persistent MySQL databases.
Return the current database size in bytes.
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.
Returns a string describing the type of connection in use. Deprecated method.
Returns quoted identifier if server supports backquote character (`).
Returns the protocol version used by current connection.
Returns list of routines available at the moment in the current database.
Returns a server version number string.
Returns MySQLadmin status info.
GetStoredProcNames (deprecated)
Returns list of stored procedures available at the moment in the current database.
Populates a string list with the Engine type of the tables.
Populates a string list with the names of tables associated with a specified database component.
Kills a thread.
Opens the connection.
Pings MySQL server.
Resets the communication channel to the server.
Cancels all updates, insertions, and deletions for the current transaction and ends the transaction.
Methods of this group execute SQL Query and return result as single value casted to XXX type.
Stops MySQL server.
Begins a new transaction against the database server.