# tMysqlConnection

Opens a connection to the specified MySQL database for reuse in the subsequent subJob or subJobs.

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

### In this section

* [tMysqlConnection Standard properties](https://help.qlik.com/talend/en-US/components/7.3/mysql/tmysqlconnection-standard-properties)

**Related concepts**

[Checking customer table against a given DQ rule to select customer records](https://help.qlik.com/talend/en-US/components/7.3/mysql/tmysqlconnection-tmysqlinvalidrows-tlogrow-tmysqlinvalidrows-tlogrow-checking-customer-table-against-given-dq-rule-to-select-customer-records-standard-component-enterprise-this)

[Getting the ID for the last inserted record with tMysqlLastInsertId](https://help.qlik.com/talend/en-US/components/7.3/mysql/tmysqlconnection-tmysqllastinsertid-tlogrow-getting-id-for-last-inserted-record-with-tmysqllastinsertid-standard-component-the)

[Inserting data in mother/daughter tables](https://help.qlik.com/talend/en-US/components/7.3/mysql/tmysqlconnection-tmysqlrollback-tfileinputdelimited-inserting-data-in-mother-daughter-tables-standard-component-the)

[Iterating on a DB table and listing its column names](https://help.qlik.com/talend/en-US/components/7.3/mysql/tmysqltablelist-tmysqlconnection-tlogrow-iterating-on-db-table-and-listing-its-column-names-standard-component-the)

[Iterating on DB tables and deleting their content using a user-defined SQL template](https://help.qlik.com/talend/en-US/components/7.3/mysql/tmysqlconnection-tmysqltablelist-tmysqltablelist-iterating-on-db-tables-and-deleting-their-content-using-user-defined-sql-template-standard-component-the)

[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)