Executing "SQL" statements

[Anonymous]

I am used to executing sql via components by other outputting data into CSVs or updating data via CSVs.  I have never needed to run SQL commands that dont really send or return data like running "truncate" on table.  Which component would be best for this? 

[vapukov]

Think it is tMySQLRow (change MySQL for Your type of database), 
if more than 1 command in same component - read about JDBC parameters specific for Your database

[cterenzi]

You can run multiple commands with a single database "Row" component by separating them with semicolons.

[vapukov]

cterenzi wrote:
You can run multiple commands with a single database "Row" component by separating them with semicolons.

in case of MySQL at least, in this case You must add
Additional JDBC Parameters   "allowMultiQueries=true"