Top Previous Next

TmySQLQuery TMySQLQuery encapsulates a dataset with a result set that is based on an SQL statement.


Use TMySQLQuery to access one or more MySQL tables in a database using SQL statements. TMySQLQuery component is useful because it can:

Access more than one table at a time (called a "join" in SQL).
Automatically access a subset of rows and columns in its underlying table(s), rather than always returning all rows and columns.

note TMySQLQuery provides BDE-like functionality and is fully compatible with TDatasource and visual DB-controls. If you need to fetch some data without displaying them you can use high-performance TMySQLDirectQuery component.

See also: Properties, Methods, Events