Data Access Components for MySQL Component List

Basic MyDAC components are included in all MyDAC editions. There are additional components in MyDAC Professional and Developer Edition. The Editions page gives full description of features and incuded 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 and Developer 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.

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.