# MySQL scenarios

* [Checking customer table against a given DQ rule to select customer records](https://help.qlik.com/talend/en-US/components/8.0/mysql/tmysqlconnection-tmysqlinvalidrows-tlogrow-tmysqlinvalidrows-tlogrow-checking-customer-table-against-given-dq-rule-to-select-customer-records-standard-component-enterprise-this)
* [Combining two flows for selective output](https://help.qlik.com/talend/en-US/components/8.0/mysql/tmysqlrow-tfixedflowinput-tparserecordset-tlogrow-combining-two-flows-for-selective-output-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)
* [Getting the ID for the last inserted record with tMysqlLastInsertId](https://help.qlik.com/talend/en-US/components/8.0/mysql/tmysqlconnection-tmysqllastinsertid-tlogrow-getting-id-for-last-inserted-record-with-tmysqllastinsertid-standard-component-the)
* [Inserting a column and altering data using tMysqlOutput](https://help.qlik.com/talend/en-US/components/8.0/mysql/tmysqloutput-tmap-trowgenerator-trowgenerator-inserting-column-and-altering-data-using-tmysqloutput-standard-component-this)
* [Inserting data in bulk in MySQL database](https://help.qlik.com/talend/en-US/components/8.0/mysql/tmysqloutputbulkexec-trowgenerator-inserting-data-in-bulk-in-mysql-database-standard-component-this)
* [Inserting data in mother/daughter tables](https://help.qlik.com/talend/en-US/components/8.0/mysql/tmysqlconnection-tmysqlrollback-tfileinputdelimited-inserting-data-in-mother-daughter-tables-standard-component-the)
* [Inserting transformed data in MySQL database](https://help.qlik.com/talend/en-US/components/8.0/mysql/tmysqlbulkexec-tmysqloutputbulk-tmap-inserting-transformed-data-in-mysql-database-standard-component-this)
* [Iterating on DB tables and deleting their content using a user-defined SQL template](https://help.qlik.com/talend/en-US/components/8.0/mysql/tmysqlconnection-tmysqltablelist-tmysqltablelist-iterating-on-db-tables-and-deleting-their-content-using-user-defined-sql-template-standard-component-the)
* [Iterating on a DB table and listing its column names](https://help.qlik.com/talend/en-US/components/8.0/mysql/tmysqltablelist-tmysqlconnection-tlogrow-iterating-on-db-table-and-listing-its-column-names-standard-component-the)
* [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)
* [Reading email addresses from a DB table and retrieving specific data](https://help.qlik.com/talend/en-US/components/8.0/mysql/tmysqlinvalidrows-tlogrow-reading-email-addresses-from-db-table-and-retrieving-specific-data-standard-component-enterprise-this)
* [Removing and regenerating a MySQL table index](https://help.qlik.com/talend/en-US/components/8.0/mysql/tmysqlrow-tmysqloutput-trowgenerator-tlogrow-removing-and-regenerating-mysql-table-index-standard-component-this)
* [Retrieving data in error with a Reject link](https://help.qlik.com/talend/en-US/components/8.0/mysql/tmysqloutput-tmap-tfileoutputdelimited-tfileinputdelimited-retrieving-data-in-error-with-reject-link-standard-component-this)
* [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)
* [Updating a database table using tMysqlOutput in a Big Data Streaming Job](https://help.qlik.com/talend/en-US/components/8.0/mysql/tmysqloutput-trowgenerator-thdfsconfiguration-thdfsconfiguration-updating-database-table-using-tmysqloutput-in-big-data-streaming-job-this)
* [Updating data using tMysqlOutput](https://help.qlik.com/talend/en-US/components/8.0/mysql/tmysqloutput-tfileinputdelimited-updating-data-using-tmysqloutput-standard-component-this)
* [Using PreparedStatement objects to query data](https://help.qlik.com/talend/en-US/components/8.0/mysql/tmysqlrow-tparserecordset-tfileinputdelimited-tfileoutputdelimited-using-preparedstatement-objects-to-query-data-standard-component-this)
* [Using tMysqlSP to find a State Label using a stored procedure](https://help.qlik.com/talend/en-US/components/8.0/mysql/tmysqlsp-trowgenerator-tlogrow-tlogrow-using-tmysqlsp-to-find-state-label-using-stored-procedure-standard-component-the)
* [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)
* [Writing dynamic columns from a source file to a database](https://help.qlik.com/talend/en-US/components/8.0/mysql/writing-dynamic-columns-from-source-file-to-database)