exec

Execute an SQL command or prepared statement, 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.MYXResultRecieved will be thrown.

Only use the string sql overload 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 overload that takes a Prepared.

More...

Parameters

conn Connection

An open mysql.connection.Connection to the database.

sql string

The SQL command to be run.

Return Value

Type: ulong

The number of rows affected.

Detailed Description

Type Mappings

$(TYPE_MAPPINGS)

Meta