# tMysqlInput

Executes a DB query with a strictly defined order which must correspond to the schema definition.

tMysqlInput reads a database and extracts fields based on a query. Then it passes on the field list to the next component via a Main row link.

Depending on the Talend product you are using, this component can be used in one, some or all of the following Job frameworks:

* Standard: see [tMysqlInput Standard properties](https://help.qlik.com/talend/en-US/components/7.2/mysql/tmysqlinput-standard-properties "These properties are used to configure tMysqlInput running in the Standard Job framework.").

  The component in this framework is available in all Talend products.

* MapReduce: see [tMysqlInput MapReduce properties](https://help.qlik.com/talend/en-US/components/7.2/mysql/tmysqlinput-mapreduce-properties "These properties are used to configure tMysqlInput running in the MapReduce Job framework.").

  The component in this framework is available in all subscription-based Talend products with Big Data and Talend Data Fabric.

* Spark Batch: see [tMysqlInput properties for Apache Spark Batch](https://help.qlik.com/talend/en-US/components/7.2/mysql/tmysqlinput-properties-for-apache-spark-batch "These properties are used to configure tMysqlInput running in the Spark Batch Job framework.").

  This component also allows you to connect and read data from a RDS Aurora or a RDS MySQL database.

  The component in this framework is available in all subscription-based Talend products with Big Data and Talend Data Fabric.