Function description

Execute the SQL statement in the target database and return the number of affected rows. It needs to be used in combination with the database connection component.

instructions

After adding the SQL statement execution component to the visual editing area, the attribute & ldquo; Output to variable & rdquo; Set the output content variable parameter in & ldquo; Target database object & rdquo; Enter the variable name of the database object in & ldquo; SQL statement & rdquo; Enter the SQL statement to be executed in & ldquo; SQL statement parameters & rdquo; Enter the parameter value in. After setting the attribute value, it runs successfully. Print the returned value to get the execution result. if属性

if属性

Attribute description

Target database object: the previously opened database link.
SQL statement: SQL statement without parameters

if属性

With parameters

if属性

SQL statement parameters: SQL statement parameters. Single parameter: ['1 '], multi parameter: ['1','2 ','3']
Output to: output to the variable.

Code description

Code example

if属性

Parameter description

if属性

Return value description

if属性

Execute SQL statement