Home / Products / VCL Database Connectivity / VCL Data Access Components / MyDAC / Components

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

	TMyConnection Lets you set up and control connections to MySQL database server.
	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.
	TMyCommand Executes SQL statements and stored procedures, which do not return rowsets.
	TMyTable Lets you retrieve and update data in a single table without writing SQL statements.
	TMyStoredProc Executes stored procedures and functions.
	TMyUpdateSQL Lets you tune update operations for a DataSet component.
	TMyDataSource Provides an interface between MyDAC dataset components and data-aware controls on a form.
	TMyScript Executes sequences of SQL statements.
	TMySQLMonitor Interface for monitoring dynamic SQL execution in MyDAC-based applications.
	TMyConnectDialog Used to build custom prompts for username, password and server name.
	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

	TMyLoader Provides quick loading data to MySQL database.
	TMyDump Serves to store a database or its parts as a script and also to restore database from received script.
	TMyBackup Serves for backup copying specified tables on the server.
	TMyServerControl Serves to control the server and execution of standard service tasks.
	TMyEmbConnection Is used to establish connection to Embedded MySQL server.
	TMyBuilder Serves to mange SQL Builder for MySQL Add-in.
	TMyMetaData Retrieves metadata on specified SQL object.
	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.