Function exec
Execute a one-off SQL command, such as INSERT/UPDATE/CREATE/etc.
This method is intended for commands such as which do not produce a result set
(otherwise, use one of the query functions instead.) If the SQL command does
produces a result set (such as SELECT), mysql
will be thrown.
Use this method when you are not going to be using the same command
repeatedly and you are CERTAIN all the data you're sending is properly
escaped. Otherwise consider using mysql.
Prototype
ulong exec(
Connection conn,
string sql
);
Parameters
| Name | Description |
|---|---|
| conn | An open Connection to the database. |
| sql | The SQL command to be run. |
Returns
The number of rows affected.