MySQL for Python

executemany(): Behind the scenes

As seen previously, it is not necessary to have an intimate knowledge of the entire process behind executemany() in order to use it. But to truly know what you are doing with it, you must follow the Python motto for learning:

Use the source, Luke!

In that vein, let's take a look at the underlying code of executemany(). The definition line indicates that executemany() requires the SQL query to be processed as well as the arguments for that statement.

def executemany(self, query, args):

As noted under executemany(): Basic syntax section, previously, both the statement and the arguments are mandatory. executemany() expects you to feed it a template for query and the values to be inserted for args.

 del self.messages[:] ...