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

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 👇 :

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

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

👉 #2 Introduction to Python MySQL Connectivity

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

👉 #5 Sending data via. Parameterized Queries

👉 #7 CRUD operations in Python with SQL

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:

Bhargab Kakati
PGT(Computer Science)

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

[UrjaAcademy]

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

[Puh]

sir last sunday and Saturday u didn't make any video and this feel miserable because I thought that u might fall sick but on monday u r back with class 11 video, I feel relaxed.
sir, if u r sick, my computer exam will be the worst.I don't feel afraid of computer exam because of ur super videos.
May God bless u so that u will never fall sick.

[harshmittal]

We see so much channels which are so popular but this is the channel where we will find very good and complete content with nice explanation. Thans sir

[Puh]

sir, I think for betterment of ur videos u can add some solve example or previous years question at the last part of each video

[debakamalhazarika]

Sir, is there any syntax to display a row by the wish of the user from anywhere in the table ?

[debakamalhazarika]

Sir, in <data>, can it be any variable or its "data" only fixed