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