Using MySQL Connector and Python to implement a database on MySQL Server, and to create, read, update and delete data in that database.
This repo accompanies this tutorial I wrote for freeCodeCamp.
The notebook takes the reader step-by-step through all the processes involved with using Python and the MySQL Connector to perform the standard CRUD functions on a database running on MySQL Server.
This repository uses code and data from this repository which accompanies my series of SQL Tutorials on Towards Data Science. If you are not familiar with relational databases and SQL, I recommend going through those tutorials first.
We will be implementing the same code to build the below database for the International Language School, but this time doing it via Python using MySQL Connector.
- Defining functions in Python
- Database Implementation
- Creating, Reading, Updating and Deleting data using SQL and Python
The data used were created by myself for an earlier project. Some participant names were created using Fake Name Generator.
- Clone this repo (for help see this tutorial).
- All code is contained within the Jupyter Notebook for this project, stored in the root folder as mysql.ipynb
All feedback is warmly received. Craig Dickson can be contacted at craigdoesdata.com.