Frends.MySQL.ExecuteProcedure / 1.1.0
Summary
Calls a stored procedure with parameters and reports how many rows it affected.
Typical use — MySQL databases where the write logic lives in the database
Input class
| Name | Type | Default | Example | Description |
|---|---|---|---|---|
| ConnectionStringSecret | String |
server=server;user=user;database=db;password=pw; |
server=server;user=user;database=db;password=pw; |
Mysql connection string |
| Query | String |
ProcedureName |
SELECT ColumnName FROM TableName |
SQL statement to execute at the data source. Usually query or name of a stored procedure. https://dev.mysql.com/doc/dev/connector-net/8.0/html/P_MySql_Data_MySqlClient_MySqlCommand_CommandText.htm |
| Parameters | Parameter[] |
– | Name: ValueName |
Parameters for the database query |