===== Insert Into MySQL Table =====

This tasks could be used to Insert data into a internal / external SQL Database.

To make use of this feature, you need to create a MySQL Provider in Provider Management. There you enter MySQL Server, Username and Password.

This Provider could be chosen in this block. **(1)** \\
You need to specify the database and table name you want to insert into. **(2)** \\
After you have done this, click the “load Structure” button. **(3)**

This click will load all columns from table and create a list you could fill with values.

**1** – You could configure a value for every column or add additional columns, if you modify the table structure after initialization.

The checkbox “set on Update” is used together with next section. \\
**2** – You could configure columns and values, which are checked before insert. \\
If a matched  column is found, no Insert, but a Update is done with the columns you set to “set on Update”.

{{ :en:start:tasks:special_tools:screen1474111142.png |}}
{{ :en:start:tasks:special_tools:screen1474111838.png |}}