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%]')