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

### In this section

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

**Related concepts**

* [Populating a MySQL data warehouse](https://help.qlik.com/talend/en-US/components/8.0/mysql/tmysqlinput-tmysqloutput-tmap-tmysqloutput-tmap-populating-mysql-data-warehouse-standard-component-enterprise-the)
* [Sharing a database connection between a parent Job and child Job](https://help.qlik.com/talend/en-US/components/8.0/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/8.0/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/8.0/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.")