SQL Statement

Actions of type Database query allow you to write custom SQL queries and execute them against a database. The database connection must have been setup in the database connection menu. The SQL statement may contain variables.

Options

Statement: The SQL statement to be executed.

Note

The statement will be executed as a so called prepared statement, which prevents SQL injection attacks. You do not need to use simple quotation marks (').

Correct

insert into test_tabelle (firstName, lastName) values ([%tfFirstName%], [%tfLastName%])

Wrong

insert into test_tabelle (firstName, lastName) values ('[%tfFirstName%]', '[%tfLastName%]')