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 together into a web application that will allow us to perform this kind of administration on MySQL remotely.
