Summary

  • How to use iteration to execute several individual INSERT statements rapidly
  • Cursor.executemany() is optimized for such iteration
  • When one should avoid using executemany()
  • Why certain errors will arise when using executemany()
  • How to throttle the amount of data we INSERT and why

In the next chapter, we will look at creating and dropping tables from within Python.

Get MySQL for Python now with the O’Reilly learning platform.

O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.

Start your free trial