Frends.MySQL.ExecuteQuery / 1.4.0
Summary
Runs SQL against MySQL and returns the result as a JToken, with parameters passed separately from the statement text.
Typical use — reading from and writing to MySQL and MariaDB; parameterising is also what keeps injection out of the query
Query input.
| Name | Type | Default | Example | Description |
|---|---|---|---|---|
| ConnectionStringSecret | String |
– | server=server;user=user;database=db;password=pw; |
Mysql connection string. |
| CommandText | String |
– | SELECT ColumnName FROM TableName |
SQL statement to execute at the data source. Usually query or name of a stored procedure. |
| Parameters | Parameter[] |
– | foo, bar |
Parameters for the database query. |