execute - full360/sneaql GitHub Wiki

Command: EXECUTE

description:

execute a SQL statement(s) following the tag.

parameters:

• optional - variable name to store rows_affected

behavior:

• every execute stores (and overwrites) 'last_statement_rows_affected' variable, but this behavior may be inconsistent when running multiple SQL statements

examples:

 /*-execute-*/ 
 set session autocommit to off;
 
 /*-execute-*/ 
 set time zone to 'UTC';
 
 /*-execute-*/
 create table if not exists public.test(x integer);
 
 /*-execute first_insert-*/ --this example stores rows_affected in variable named 'first_insert'
 insert into public.test values (1);