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

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 [tMysqlOutput Standard properties](https://help.qlik.com/talend/en-US/components/7.3/mysql/tmysqloutput-standard-properties).

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

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

  The component in this framework is available in all Talend products with Big Data and Talend Data Fabric.

* Spark Batch: see [tMysqlOutput properties for Apache Spark Batch](https://help.qlik.com/talend/en-US/components/7.3/mysql/tmysqloutput-properties-for-apache-spark-batch).

  This component can also be used to write data to 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.

* Spark Streaming: see [tMysqlOutput properties for Apache Spark Streaming](https://help.qlik.com/talend/en-US/components/7.3/mysql/tmysqloutput-properties-for-apache-spark-streaming).

  This component can also be used to write data to a RDS Aurora or a RDS MySQL database.

  This component is available in Talend Real Time Big Data Platform and Talend Data Fabric.

### In this section

* [tMysqlOutput Standard properties](https://help.qlik.com/talend/en-US/components/7.3/mysql/tmysqloutput-standard-properties)
* [tMysqlOutput MapReduce properties (deprecated)](https://help.qlik.com/talend/en-US/components/7.3/mysql/tmysqloutput-mapreduce-properties-deprecated)
* [tMysqlOutput properties for Apache Spark Batch](https://help.qlik.com/talend/en-US/components/7.3/mysql/tmysqloutput-properties-for-apache-spark-batch)
* [tMysqlOutput properties for Apache Spark Streaming](https://help.qlik.com/talend/en-US/components/7.3/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/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.")

[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 a column and altering data using tMysqlOutput](https://help.qlik.com/talend/en-US/components/7.3/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/7.3/mysql/tmysqlconnection-tmysqlrollback-tfileinputdelimited-inserting-data-in-mother-daughter-tables-standard-component-the)

[Removing and regenerating a MySQL table index](https://help.qlik.com/talend/en-US/components/7.3/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/7.3/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/7.3/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/7.3/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/7.3/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/7.3/mysql/writing-dynamic-columns-from-source-file-to-database)