Execute SQL

Command description

Execute SQL statements such as CREATE TABLE, INSERT, DELETE, UPDATE, and SELECT. Placeholder parameters are supported.

Command Input Parameters

input parameters	Input parameter type	Description
SQL Connection Object	SQLConnection
SQL	str	SQL statements, such as INSERT INTO users(name, age) VALUES(:name, :age)
Arguments	PythonExpression	Placeholder parameters in SQL statements, such as [{'name':'xl', 'age':10}, {'name':'zs', 'age':12}]

Command Output Parameters

Output parameters	Output parameter type	Description
Result	any	SQL execution results

Sample Workflow