•  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 and provides flexible data update functionality

•  TMyTable - allows to retrieve and update data single table without writing SQL statement

•  TMyStoredProc - executes stored procedures and functions

•  TMyCommand - executes SQL statements and stored procedures, which do not return rowsets

•  TMyScript - executes sequence of SQL statements

•  TMyUpdateSQL - lets you tune update operations for a DataSet component

•  TMyDataSource - provides an interface between a MyDAC dataset components and data-aware controls on a form

•  TMySQLMonitor - allows to monitor dynamic SQL executing in MyDAC based applications

•  TMyConnectDialog - allows you to build custom prompts for usernames, passwords, and servers

•  TCRDBGrid - extends TDBGrid capabilities, provides visual access to filters and incremental search

•  TVirtualTable - provides dataset functionality for data that has no real database connection

•  MyDataAdapter - .NET component, uses TDataSet as data source for retrieving and saving data to System.Data.DataSet

•  MyDAC Professional Edition and MyDAC Developer Edition include the following additional 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 MySQL Embedded server

•  TMyBuilder - serves to manage SQL Builder for MySQL Add-in

•  TMyMetaData - retrieves metadata on specified SQL object

•  TCRBatchMove - transfers data between all types of TDataSet descendants

•  Direct access to server data without using client library. Does not require installation of other data provider layers (such as BDE and ODBC)

•  VCL, VCL.NET, and CLX versions of library available

•  Full support of the latest versions of MySQL Server

• Support for all MySQL Server data types

•  Disconnected Model with automatic connection control for working with data offline

•  Local Failover for detecting connection loss and implicitly reexecuting certain operations

•  All types of local sorting and filtering, including by calculated and lookup fields

•  Automatic data updating with TMyQuery, TMyTable, and TMyStoredProc components

• Unicode and national charset support

•  Supports many MySQL-specific features, such as locking, SET and ENUM types

•  Advanced script execution functionality with TMyScript component

• Support for using macros in SQL

•  Integration with MyDeveloper Tools for performing advanced database development and administration tasks

•  Easy migration from BDE with Migration Wizard

•  Lets you use Professional Edition of Delphi and C++Builder to develop client/server applications

•  Includes annual MyDAC Subscription with Priority Support

•  Licensed royalty-free per developer, per team, or per site

Components
 All editions of MyDAC include the following basic 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 and provides flexible data update functionality
• TMyTable - allows to retrieve and update data single table without writing SQL statement
• TMyStoredProc - executes stored procedures and functions
• TMyCommand - executes SQL statements and stored procedures, which do not return rowsets
• TMyScript - executes sequence of SQL statements
• TMyUpdateSQL - lets you tune update operations for a DataSet component
• TMyDataSource - provides an interface between a MyDAC dataset components and data-aware controls on a form
• TMySQLMonitor - allows to monitor dynamic SQL executing in MyDAC based applications
• TMyConnectDialog - allows you to build custom prompts for usernames, passwords, and servers
• TCRDBGrid - extends TDBGrid capabilities, provides visual access to filters and incremental search
• TVirtualTable - provides dataset functionality for data that has no real database connection
• MyDataAdapter - .NET component, uses TDataSet as data source for retrieving and saving data to System.Data.DataSet
• MyDAC Professional Edition and MyDAC Developer Edition include the following additional 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 MySQL Embedded server
• TMyBuilder - serves to manage SQL Builder for MySQL Add-in
• TMyMetaData - retrieves metadata on specified SQL object
• TCRBatchMove - transfers data between all types of TDataSet descendants

Key Features
 The following list describes the main features of Data Access Components for MySQL.

• Direct access to server data without using client library. Does not require installation of other data provider layers (such as BDE and ODBC)
• VCL, VCL.NET, and CLX versions of library available
• Full support of the latest versions of MySQL Server
• Support for all MySQL Server data types
• Disconnected Model with automatic connection control for working with data offline
• Local Failover for detecting connection loss and implicitly reexecuting certain operations
• All types of local sorting and filtering, including by calculated and lookup fields
• Automatic data updating with TMyQuery, TMyTable, and TMyStoredProc components
• Unicode and national charset support
• Supports many MySQL-specific features, such as locking, SET and ENUM types
• Advanced script execution functionality with TMyScript component
• Support for using macros in SQL
• Integration with MyDeveloper Tools for performing advanced database development and administration tasks
• Easy migration from BDE with Migration Wizard
• Lets you use Professional Edition of Delphi and C++Builder to develop client/server applications
• Includes annual MyDAC Subscription with Priority Support
• Licensed royalty-free per developer, per team, or per site