Python Programming - 28 - Working with MySQL Database-Data Manipulation|Python Programming in Tamil
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/2...
2. Python-MySQL Connector Installation - • Python Programming - 17 - PIP - Package In...
3. XAMPP Installation - https://letussharehere.blogspot.com/2...
4. MySQL Server Installation - https://letussharehere.blogspot.com/2...
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
**************************************