Interface Python with MYSQL | Important Question Answers | Class 12 Computer Science
HTML-код
- Опубликовано: 14 окт 2024
- Interface Python with MYSQL
Interface Python with MYSQL (Part - 1)
• Python Connectivity wi...
How to install MYSQL Connector in Windows 10?
• How to install mysql c...
FETCHALL( ) , FETCHONE( ) , FETCHMANY() , ROWCOUNT
• Display Data by using ...
Parameterized Queries
• PARAMETERIZED QUERIES ...
Performing Insert, Update and Delete Operations, while connecting Python with MYSQL
• Performing Insert, Upd...
Create database , Table and insert multiple rows (Taking input from users)
• Create database , Tabl...
1 Shot Video of Interface Python with MYSQL
• Interface Python with ...
Join this channel to get access to perks:
/ @swatichawlaofficial
YT 1k Sub.
• Thank You my Viewers (...
Channel Trailer video
• Check it out !!! What ...
random module
• random module
Mathematical and String Functions
• Playlist
Using Python Libraries:
• Using Python Libraries
Data Structures: Stack and Queue
• Data Structures : Line...
File Handling:
• File Handling
Recursion
• Recursion
Idea of Algorithmic Efficiency
www.youtube.co...
Interface Python with MYSQL:
• Interface Python with ...
MYSQL
• MYSQL
Computer Networks:
• Computer Networks
Programming Corner:
• Programming Corner
Output Based Questions:
• Output Based Questions
Boolean Algebra
• Boolean Algebra
Basics of Python
• Python Introduction, F...
Flow of Control
• Flow of Control (Condi...
String Manipulation
• String Manipulation
List Manipulation
• List Manipulation
Dictionaries
• Dictionaries in Python
Sorting
• Playlist
mam isse pehle ye chapter ka name sunte hi mera dimag kharab ho jaata tha ......pr aapki jo one shot video he wo nd ye questions waali video dekh kr hi pura chapter smjh aagaya .......BOHOT BOHOT SHUKRIYA MAM CHARANSPARSH radhe radhe
Glad it was Helpful !!!
Thanku so much...
Radhe Radhe 🙏🏼 🙏🏼
Mam thank you very much mam aapki video mere bohot kaam aaye .
Kiyunki kl practical hai mera
That's great..
Best wishes for ur exam..
Mam in oswaal question books they are doing question with try and except block but mam i am using only your process as it is very easy to understand for me. Mam both are same? Means if I do yours process school will not cut my marks? Mam another qury of mine is do you have any telegram group do that i can send two question which I am facing doubt.
I was really confused with this topic but it's all cleared now thank you !!
Glad it helped!
Thanku so much...
Keep watching..
hey are you persuing btech now
Very thankful for you efforts to help us in learning python
Glad to hear that
Thank You so much..
Keep Watching...
Name the built in string function that is used to return a version of the string suitable for caseless comparison?.. ma'am.. this question pls
casefold()
MAM , i have a question , this question is coming in my board cs practical
Q1 Write a python script to connect to the data base TEST .Accept roll number as parameter and find out whether record is present in the table named Student with the following fields(rollno, name, DOB, Total, Perc)
ma'am aapka sara video dekha bhi or share bhi kiye THANKS A LOT MA'AM
so nice of u...thanku...
Thanku uso much ma'am❤️❤️ Today completed Term 2 syllabus with your videos. Awesome content and to the point , everything crystal clear 👍👍And able to do these type of questions 😀😀😀 thanks very much ❤️❤️
Thanks and Welcome...
Keep Watching
waiting for such more videos.
Amazing content and explanation
My pleasure
Mam great thanks to you ❤️ finally I solved all the questions after seeing the playlist ❤️ Mam playlist is really helpful AND. ........... KEEP IT UP👍
You are not only good teacher but hubmle good human being also, thank you
Thank you ma'am You explained everything in detail..🎉🎉🙏🙏
My pleasure 😊
Thank you madam for your good explanation. By your explanation we can understand easily.
Glad to hear that
Thank You so much....
Best channel ever seen
Thanku so much...
Keep Watching
Mam one general doubt that in interface python with MySQL, while writing query why don't we end query with semicolon?
Like query ="select * from student"
Not like this, query ="select * from student;"
Try to execute practically...both ways in Python..
Generally we don't need a semicolon at the end of the statement in Python, that's why not used..
Whereas in MySQL, we use that
17:00 ma'am we just can't do this. We have to use fetchall function to retrieve data.
Previous years k questions h ye?
34:11 Ma'am in Q5 shouldn't it be cursor.execute(____________) instead of db.execute(______________)?db is connection object so how can we use it to execute the query as we should use cursor instance to execute the query ,right? Kindly clarify Ma'am pls..
Yes...u r right..
It was by mistake..
Sorry for the inconvenience caused..
@@SwatiChawlaofficial Ok ma'am thank you so much.. Kindly don't say sorry ☺️❤️
Most Welcome.. 🙂
Thanks u so much mam now my all concept related to this ch is clear 😊
Most welcome 😊
Thank you ma'am. You're savior.
Ma'am if I use normal insert, delete n update of MySQL ininterface with python without using parameterised query So will I be using commit function or not ?
yes...commit() function is used to save the changes in a data base..
Thank u so much ma'am
Most welcome 😊
15:00 one more closing bracket should come mam?
Mam, in book they says that we use commit command for update, insert and delete??
Yes
Yes we have to use commit
Mam in update we will not use paramerised query??
It's really helpful , thank you ma'am 💛💛
Most welcome 😊
Maam at 15:54,
Sorry to say but there should be execution of query.
democursor. execute(q)
Pls let me know if I m wrong.
yes u r right...execute() will be called to execute the query.
Mam have you covered all chapters and topics (excluding deleted portion) for 12th class
yes...plz check the playlist except Recursion and Idea of Algorithmic Efficiency are all according to revised syllabus...
@@SwatiChawlaofficial ok madam
@@SwatiChawlaofficial recursion and algorithmic efficiency?
What is it?
@@oathkeeper2498 deleted topics
@@SwatiChawlaofficial 😊👍
Mam in questions ki link de dejiye please 🙏🙏🙏🙏🙏🙏🙏🙏🙏🙏🙏🙏🙏🙏🙏
Thank you so much mam for this much efforts. You are great☺☺
So nice of you
Thank you....
Thank you mam 💞
For such great video 📸
Thanks and Welcome
Mam will you make a video on society law and ethics ??
Yes...but this chapter is in class 11 now..not in class 12.. according to cbse curriculum 2020-21
Welcome
Ma'am at 25:21, shouldn't cursor.execute(sql) be used instead of db.execute(sql)?
yes..
Thank You mam completed for term 2 😊
Most Welcome
Mam can you suggest any question bank book for cbse board exam
Thankyou so much much 😍
Most welcome 😊
AT 14:05 in question 13 ma'am in last line one bracket has been missed that has to be put before colon.
Yes..
Hello mam, can u share the pdf of these questions. Need them for preparation.
Sure..You can enjoy special perks by joining the membership.
Have a look at this.
ruclips.net/channel/UC2vH9rqGh-fJELF8acGfBdwjoin
Ma'am 3:15 AM ho rhe h 😅😅😅 aaj 7:30 pr school ke Board ka Practical h ! 🙂
Din raat ek kr denge pr no. Kam nhi aane chayiye !!
Yes...That's the spirit!!!
Best Wishes for your exam...
mam can i get personal classes or tuition
Already Everything is uploaded...free of cost... Quality content is there..
Please check out the channel
From where to start,
I mean the order of chapter for study purpose
Interface python with mysql
File Handling
Mysql
.....
If the order is not this
Pls tell the order of full chapters correctly, that (lectures)you have taken through RUclips
Python Revison Tour
Functions
Python Libraries
random module
Mathematical and String Functions
Linear List
Data Structures
File Handling
Mysql
Interface Python with Mysql
Computer Networking
@@SwatiChawlaofficial mam can you pls give me your WhatsApp number, so that i can clarify my doubts 😊
Or do you want my WhatsApp number
U can ask ur queries here
@@SwatiChawlaofficial ok then 😊👍
Make can u make this execution practically?
ruclips.net/p/PL5Raijva2y4QBzhQw5OWIn9Dopl_M_NEE
Could we get pdf of this lecture?
Sure... You can enjoy special perks by joining the membership.
Have a look at this.
ruclips.net/channel/UC2vH9rqGh-fJELF8acGfBdwjoin
Please provides notes of your lectures also mam
Great lectures great content
Really appreciate you hard work ❤️
Bhai uske liye tum join kr lo
Ma'am vha de deti h sb notes ! Yeh toh kuch nhi aur kitne notes mil jaayenge tumhe
Amazing mam🥰thank youuu
Most welcome 😊
Mam please help .. where is unit society ,laws n ethics ?? Is smthing like this in our syllaus.. can u plz provide m the syllabus of computer which chapter v hv to do for our cbse board exam... M very much confused mam 😭😭😭😭😭😭 plz help
Societal Law and ethics is not in your curriculum now for session 2020-21 in class 12..
Check out the Revised curriculum
ruclips.net/video/4MSy61D485E/видео.html
See the cbse updated syllabus..
u rock mam
Thanku
Mam may you plz provide pdf pf this lecture
Sure..You can enjoy special perks by joining the membership.
Have a look at this.
ruclips.net/channel/UC2vH9rqGh-fJELF8acGfBdwjoin
Mam I am unable to understand the try and except in question 13 can u please help mam
ruclips.net/video/nQrLMrVpZJI/видео.html
Mam kal exam hai apki ye video dekh ke chapter finish samjh rha hu kal aa ke response batunga 😂
😀😀
All the best
It's been 6 months bhai ka kuch atta pta nhi 💀
for python basics
Mam what is the meaning of interface here.
means by which interaction or communication or connectivity is done using Python and MySQL.
@@SwatiChawlaofficial ok mam tnx
maam what is rollback used for?
ROLLBACK is a transactional control language in SQL. It lets a user undo those transactions that aren't saved yet in the database. One can make use of this command if they wish to undo any changes or alterations since the execution of the last COMMIT.
@@SwatiChawlaofficial oh ok got it maam. Thank you so much
Welcome
Mam where we get these notes
Sure..You can enjoy special perks by joining the membership.
Have a look at this.
ruclips.net/channel/UC2vH9rqGh-fJELF8acGfBdwjoin
Mam aap 2022 23 ka computer science nhi shuru kar rhe
Mam without membership how I will get these pdf
nice video👍
Thanku....🙏🏻😊
Mam pattern programs
Done
Mam , please provide this pdf
Sure... You can enjoy special perks by joining the membership.
Have a look at this.
ruclips.net/channel/UC2vH9rqGh-fJELF8acGfBdwjoin
Mam muje apse kuch connectivity ke questions puchne hai to ap apna WhatsApp no. De skte ho
CHeck out this...after watching all these videos, ur doubts will get clear..ruclips.net/p/PL5Raijva2y4QBzhQw5OWIn9Dopl_M_NEE
@@SwatiChawlaofficial ok mam