# tMysqlOutputBulk

Writes a file with columns based on the defined delimiter and the MySQL or Aurora standards.

The tMysqlOutputBulk and tMysqlBulkExec components are used together in a two step process. In the first step, an output file is generated. In the second step, this file is used in the INSERT statement used to feed a database. These two steps are fused together in the tMysqlOutputBulkExec component, detailed in a separate section. The advantage of using two separate steps is that the data can be transformed before it is loaded in the database.

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

### In this section

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

**Related concepts**

[Inserting transformed data in MySQL database](https://help.qlik.com/talend/en-US/components/7.3/mysql/tmysqlbulkexec-tmysqloutputbulk-tmap-inserting-transformed-data-in-mysql-database-standard-component-this)