Python can be used in database applications. One of the most popular databases is MySQL. There are the following steps to connect a python application to our database.
- Import mysql.connector module
- Create the connection object.
- Create the cursor object
- Execute the query
In this project we have implemented the basic functionalities of SQL which are as follows:-
- Insert New User
- Fetch all users
- Delete a user
- Update user