# tMysqlOutput

Writes, updates, makes changes or suppresses entries in a database.

tMysqlOutput executes the action defined on the table and/or on the data contained in the table, based on the flow incoming from the preceding component in the Job.

### In this section

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

**Related concepts**

* [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.")
* [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 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)
* [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)
* [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)
* [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)