© Jesper Wisborg Krogh 2018
Jesper Wisborg KroghMySQL Connector/Python Revealedhttps://doi.org/10.1007/978-1-4842-3694-9_4

4. Advanced Query Execution

Jesper Wisborg Krogh1 
(1)
Hornsby, New South Wales, Australia
 

In the previous chapter, you looked at the basics of executing queries. This chapter explores additional features related to query execution. It starts out by looking into the options of executing multiple queries in one API call and then moves on to features such as buffered results, calling stored procedures, and loading data in CSV files.

The second half of the chapter focuses on the connection properties, how to execute transactions, using the default database property to avoid specifying the database name explicitly for each table, and ...

Get MySQL Connector/Python Revealed: SQL and NoSQL Data Storage Using MySQL for Python Programmers now with O’Reilly online learning.

O’Reilly members experience live online training, plus books, videos, and digital content from 200+ publishers.