# 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.

For more technologies supported by Talend, see [Talend components](https://help.qlik.com/talend/r/en-US/7.3/components/mysql).

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.3/mysql/tmysqlinput-standard-properties).

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

* MapReduce: see [tMysqlInput MapReduce properties (deprecated)](https://help.qlik.com/talend/en-US/components/7.3/mysql/tmysqlinput-mapreduce-properties-deprecated).

  The component in this framework is available in all 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.3/mysql/tmysqlinput-properties-for-apache-spark-batch).

  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 Talend products with Big Data and Talend Data Fabric.

### In this section

* [tMysqlInput Standard properties](https://help.qlik.com/talend/en-US/components/7.3/mysql/tmysqlinput-standard-properties)
* [tMysqlInput MapReduce properties (deprecated)](https://help.qlik.com/talend/en-US/components/7.3/mysql/tmysqlinput-mapreduce-properties-deprecated)
* [tMysqlInput properties for Apache Spark Batch](https://help.qlik.com/talend/en-US/components/7.3/mysql/tmysqlinput-properties-for-apache-spark-batch)

**Related concepts**

[Sharing a database connection between a parent Job and child Job](https://help.qlik.com/talend/en-US/components/7.3/mysql/tmysqlconnection-tmysqlinput-tlogrow-sharing-database-connection-between-parent-job-and-child-job-standard-component-this)

[Writing columns from a MySQL database to an output file using tMysqlInput](https://help.qlik.com/talend/en-US/components/7.3/mysql/tmysqlinput-tfileoutputdelimited-writing-columns-from-mysql-database-to-output-file-using-tmysqlinput-standard-component-in-this)

[Controlling the data definition language via tMysqlOutput when creating a table](https://help.qlik.com/talend/en-US/components/7.3/mysql/controlling-data-definition-language-via-tmysqloutput "This scenario shows how to create a MySQL table with an AUTO_INCREMENT column and a UNIQUE one with tMysqlOutput component.")