The MariaDB INSERT action is used to execute an insert statement against a MariaDB database.
The input parameters for an insert statement are:
| Parameter | Type | Required | Description |
|---|---|---|---|
| query | String | Required | The query to execute against the database |
| metadata | JSON | Optional | The list of parameters to pass to the query |
The metadata parameter can be used to pass variables into the query parameter.
For example, if the contents of metadata are:
{
"type" : "mint"
}
This can be used in the query parameter as:
INSERT INTO flavors (flavor)
VALUES ({type});
Note: The { } are declared without quotations.
The output parameters from an insert statement are:
| Parameter | Type | Required | Description |
|---|---|---|---|
| result | Integer | Optional | The number of rows in the database that were affected by the statement |