Chapter 7. Storing Data in Our MySQL Database via Our GUI
In this chapter we will enhance our Python GUI by connecting to a MySQL database.
- Connecting to a MySQL database from Python
- Configuring the MySQL connection
- Designing the Python GUI database
- Using the SQL INSERT command
- Using the SQL UPDATE command
- Using the SQL DELETE command
- Storing and retrieving data from our MySQL database
Introduction
Before we can connect to a MySQL server, we have to have access to a MySQL server. The first recipe in this chapter will show you how to install the free MySQL Server Community Edition.
After successfully connecting to a running instance of our MySQL server, we will design and create a database that will accept a book title, which could be our own journal or ...
Get Python GUI Programming Cookbook 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.
