Batch execution of SQL statements

Function description

  Execute SQL statements in batch 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 a batch execution SQL statement component to the visual editing area, you can set 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.    

  

Attribute description

• Target database object: the previously opened database link.
• SQL statement: SQL statement format

  

  Without parameters

  

  With parameters

  

• SQL statement parameters: SQL statement parameters. Single execution: ['4 ',' Zhao Yun '], multiple execution: ['5', 'Huang Zhong'], ['6 ',' Ma Chao '], ['7', 'Wei Yan']]
• Output to: output to the variable.

Code description

• Code example 

  

• Parameter description

  

• Return value description