About the Tutorial

22.
 
Python 3 – MySQL Database Access ...................................................................................................... 375
 
What is PyMySQL ? ...................................................................................................................................... 375
 
How do I Install PyMySQL? .......................................................................................................................... 376
 
Database Connection .................................................................................................................................. 376
 
Creating Database Table .............................................................................................................................. 377
 
INSERT Operation ........................................................................................................................................ 378
 
READ Operation ........................................................................................................................................... 380
 
Update Operation ........................................................................................................................................ 382
 
DELETE Operation ........................................................................................................................................ 383
 
Performing Transactions ............................................................................................................................. 383
 
COMMIT Operation ..................................................................................................................................... 384
 
ROLLBACK Operation ................................................................................................................................... 384
 
Disconnecting Database .............................................................................................................................. 384
 
Handling Errors ............................................................................................................................................ 385