#3 Data Extraction from SQL via Python | Interface Python with MySQL | Class 12 Computer Science

Published: 28 July 2020
on channel: Urja Academy

2,076

Welcome to the Part 3 of the Chapter Interface Python with MySQL for class 12 CBSE Computer Science .
In this video I have discussed how to extract data from a relation(table) in SQL and display it with the help of Python Programming Language.

If python is not already added to path , you can watch my video on the same by clicking on the link below 👇 :
   • How to add Python to path in Windows

If you haven't installed mysql connector , click on the link below 👇 for the detailed installation steps :

👉 #1 How to install mysql connector in python
   • #1 Install mysql connector in python | Int...

Click on the links below for the other parts of this chapter :

👉 #2 Introduction to Python MySQL Connectivity
   • #2 Introduction to Python MySQL Connectivi...

👉 #4 Performing SQL Queries via Python | insert , update and delete query
   • #4 Performing SQL Queries via Python |  In...

👉 #5 Sending data via. Parameterized Queries
   • #5 Parameterized Queries | Interface Pytho...

👉 #7 CRUD operations in Python with SQL
   • #7 CRUD Operations in Python with SQL | In...

Topics:
00:00 Intro
00:34 Creating a Cursor Instance
02:35 Executing SQL Query from Python
04:17 Concept of Result Set
04:49 Ways to extract data from SQL via Python:
05:11 fetchone()
15:19 fetchall()
21:44 fetchmany()
26:41 Row Count property of cursor objects

Practical demonstration programs with all data extraction functions

Connect on these social media Handles:

👉 Instagram:   / bhargab_kakati

👉 LinkedIn :   / bhargabkakati

👉 Twitter :   / bhargab008

Bhargab Kakati
PGT(Computer Science)

#Python #mysqlconnector #PythonMySQL #fetchone #fetchall #fetchmany

On this page of the site you can watch the video online #3 Data Extraction from SQL via Python | Interface Python with MySQL | Class 12 Computer Science with a duration of hours minute second in good quality, which was uploaded by the user Urja Academy 28 July 2020, share the link with friends and acquaintances, this video has already been watched 2,076 times on youtube and it was liked by 37 viewers. Enjoy your viewing!