This video explains and demonstrates how to work with MySQL database using Python.
We will focus on data manipulation - insert data, update data, delete data and update data.
References:
---------------------
1. Python Installation - https://letussharehere.blogspot.com/2021/06/python-installation-in-windows.html
2. Python-MySQL Connector Installation - https://youtu.be/P0LSWWI3ZVo?t=665
3. XAMPP Installation - https://letussharehere.blogspot.com/2020/08/php-installation-using-xampp.html
4. MySQL Server Installation - https://letussharehere.blogspot.com/2020/01/mysql-server-installation-on-windows.html
Python Programming - 28 covers:
*************************************
00:00 Data Manipulation
00:36 Inserting single record
05:03 Inserting multiple records
09:25 Updating record
14:37 Deleting record
16:36 Retrieving all records
17:41 Retrieving single record
19:17 Retrieving fields
20:43 Retrieving using filters
20:58 - using WHERE clause
22:39 - using Wildcard characters
23:53 - Preventing SQL Injection
24:25 Sorting Results
25:16 Limiting Results
26:41 Joins - Creating 2 tables and inserting data
30:37 - Inner Join
31:49 - Left Join
32:45 - Right Join
34:34 Integrating Data to Application in the next video
**************************************
Happy Learning & Happy Coding
**************************************
