Python MySQL
We can connect to a MySQL database from our Python application, and perform required database operations.
The following series of tutorials explain most occurring scenarios when using MySQL database in a Python application.
Table Row Operations
- Python MySQL – Insert single row into table
- Python MySQL – Insert multiple rows into table
- Python MySQL – Get all rows from table
- Python MySQL – Get first row in table
- Python MySQL – Get rows from table based on condition
- Python MySQL – Iterate over all rows in table
- Python MySQL – Get rows from table sorted in order based on a column
- Python MySQL – Limit number of rows selected from table
- Python MySQL – Delete rows from table based on condition
- Python MySQL – Delete all rows