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.exceptions.MySQLResultRecievedException 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.prepared.Prepared.

ulong
exec

Parameters

conn Connection

An open Connection to the database.

sql string

The SQL command to be run.

Return Value

Type: ulong

The number of rows affected.

Meta