# Controlling the data definition language via tMysqlOutput when creating a table

This scenario shows how to create a MySQL table with an AUTO\_INCREMENT column and a UNIQUE one with tMysqlOutput component.

### In this section

* [Creating the Job and linking the components](https://help.qlik.com/talend/en-US/components/7.2/mysql/tmysqloutput-tmysqlinput-creating-job-and-linking-components-drag)
* [Configuring the components](https://help.qlik.com/talend/en-US/components/7.2/mysql/tmysqloutput-tmysqlinput-configuring-components-you-have)
* [Executing the Job](https://help.qlik.com/talend/en-US/components/7.2/mysql/tmysqloutput-tmysqlinput-executing-job-press)

**Related concepts**

[tMysqlOutput](https://help.qlik.com/talend/en-US/components/7.2/mysql/tmysqloutput "Writes, updates, makes changes or suppresses entries in a database.")

[tMysqlInput](https://help.qlik.com/talend/en-US/components/7.2/mysql/tmysqlinput "Executes a DB query with a strictly defined order which must correspond to the schema definition.")