MySQL Data Access Components Component List

Basic MyDAC components are included in all MyDAC editions. There are additional components in MyDAC Professional Edition. The Editions page gives full description of features and included components of each edition.

Basic MyDAC components

MyConnection TMyConnection

Lets you set up and control connections to MySQL database server.

MyQuery TMyQuery

Uses SQL statements to retrieve data from MySQL table or tables and supply it to one or more data-aware components through a TDataSource component. Provides flexible data update functionality.

MyCommand TMyCommand

Executes SQL statements and stored procedures, which do not return rowsets.

MyTable TMyTable

Lets you retrieve and update data in a single table without writing SQL statements.

MyStoredProc TMyStoredProc

Executes stored procedures and functions.

MyUpdateSQL TMyUpdateSQL

Lets you tune update operations for a DataSet component.

MyDataSource TMyDataSource

Provides an interface between MyDAC dataset components and data-aware controls on a form.

MyScript TMyScript

Executes sequences of SQL statements.

MySQLMonitor TMySQLMonitor

Interface for monitoring dynamic SQL execution in MyDAC-based applications.

MyConnectDialog TMyConnectDialog

Used to build custom prompts for username, password and server name.

VirtualTable TVirtualTable

Dataset that stores data in memory. This component is placed on the Data Access page of the Component palette, not on the MySQL Access page.

MyDAC Professional Edition components

MyLoader TMyLoader

Provides quick loading data to MySQL database.

MyDump TMyDump

Serves to store a database or its parts as a script and also to restore database from received script.

MyBackup TMyBackup

Serves for backup copying specified tables on the server.

MyServerControl TMyServerControl

Serves to control the server and execution of standard service tasks.

MyEmbConnection TMyEmbConnection

Is used to establish connection to Embedded MySQL server.

MyBuilder TMyBuilder

Serves to mange SQL Builder for MySQL Add-in.

MyMetaData TMyMetaData

Retrieves metadata on specified SQL object.

MyEncryptor

TMyEncryptor
Represents data encryption and decryption in client application.

CRBatchMove TCRBatchMove

Transfers data between all types of TDataSets descendants. This component is placed on the Data Access page of the Component palette, not on the MySQL Access page.


MySQL Data Access Components