O'Reilly logo

MySQL for Python by Albert Lukaszewski, PhD

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

Chapter 7. Creating and Dropping

The secret to all effective programming lies in abstracting problems so we can leverage the power of the computer to our benefit. The more we can abstract a problem and still get the same results, the more we leverage the power of the computer, and the less work the end user has to do. Abstraction provides opportunity for automation.

In addition to allowing dynamic insertion and retrieval of information, MySQL for Python allows us to automate database and table creation and removal. In this chapter, we will see:

  • How to create and delete both databases and tables in MySQL
  • How to manage database instances with MySQL for Python
  • Ways to automate database and table creation

At the end of the chapter, we will put these dynamics ...

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, interactive tutorials, and more.

Start Free Trial

No credit card required