#1 Python-MySQL | Database Connectivity

About Video:
--------------------
Learn how to use mysql database through Python code.
This series consist of 8 videos, covering
1) Database Connectivity • #1 Python-MySQL | Data...
2) Creating Database • #2 Python-MySQL | Crea...
3) Creating Table • #3 Python-MySQL | Crea...
4) Inserting Data into Table • #4 Python-MySQL | Inse...
5) Inserting Multiple Data into Table • #5 Python-MySQL | Inse...
6) Extracting data from Table • #6 Python-MySQL | Extr...
7) Updating Table Records • #7 Python-MySQL | Upda...
8) Deleting Table Records • #8 Python-MySQL | Dele...
Connect with me
------------------------------
MySirG Instagram- / mysirg
Shahid Instagram- / shahidify
My Twitter- / @sshukla_manit
MySirG Facebook- / mysirg
How to access Free or Paid learning videos?
-----------------------------------------------------------------------
Visit: MySirG.com
Visit: premium.mysirg.com
Most Valued course- Python for beginners, Javascript in depth
How to join coaching in Bhopal?
---------------------------------------------------
Visit saurabhshuklaclasses.com
Popular Searches
----------------------------
Python by Saurabh Shukla Sir
Python by Saurabh Sir
Javascript
GUI Python
Web Python
Full Stack development
C Language
C++ Language
Data Structure
PHP-MySQL
DBMS
Java
Android
Like, Comments, Share and SUBSCRIBE

[@raviagrawal6733]

Thnku so much sir for this content....
Ur videos very helpful for my career.

[@princecse]

Thank you sir I am eagerly waiting for your detailed and wounderful explanation

[@ayush4788]

Thank you sir
For making python database connectivity related video 👍👍👈👈
Please making all separate video further related to it. Because we are waiting for it. Thank you so much 👍👍👍👍👈👈👈👈👈

[@mohangouda4212]

Sir your videos are much better for interview preparation

[@ramkumarshukla4365]

Thankyou sir , we are eagerly waiting for this video 👌👌

[@ayush4788]

All guys who are waiting for next video and watching this video
Please like,share as well do comment .because
Saurabh sir is really great teacher .
Thank you so much

[@sourodipbanerjee]

Sir This is Amazing, Thank you.

[@abhayagarwal5097]

Great video ,keep them coming sir!👍😊

[@silentadmirer6961]

HELPFUL- THANK YOU!

[@manish5.052]

apki video main humesha dekhta thanku very much sir

[@zakriabacha2477]

one of the major difference i observe in surab shukla from other on RUclips is that " He make learner to think and solve problem step wise. He himself first deep thought how to keep continue the student through tutorial.

[@sohailakhtar7932]

Sir, One more thing to say.... Please provide videos on Python data structure sir as in every interview they are asking Data structure and I am little confused about this topic

[@rahulsenma7174]

Thank you sir ...I also learn a Python

[@mohangouda4212]

Sir i have an addiction to this channel when ever i see an video of these channel i do it

[@saddamahmad2310]

thank you very much sir for this video

[@gauravgaur8104]

big big tnx to you sir starting this topic

[@MOHDYASEEN-ue2dx]

🙏💕🙏💕🙏💕🙏💕🙏💕
Thank you.... Sir G...
I am waiting... For next video

[@pushpajitbiswas3752]

Legendary explanation technique is now coming again, I'm waiting for it

[@shlokrajpoot8385]

Kya aapka problem solve hua
Mean, run hua ya nhi

[@vinaypratap620]

Ok sir mai java advance chahta tha but Python ke liye dil se thank you so much sir and happy dhsehra

[@maheshgharage8480]

Very nice
Simple and important information

[@shivprakashsharma3690]

Thank you so much sir ,

[@dailyjourneybyashish]

Very nice Sir aap ka padane ka tarika Awsm hai SirG 🤩

[@engrbasitkhan4976]

thanks sir for knowledgibal vidios

[@sonamkori8169]

Sir please keep making such videos

[@mohddilshad8685]

I would like to thank for your amazing works....
Sir, I have one problem I tried to install mysql and connector for python but I am unable to install this..... although I had downloaded....pls share a video link or something like that can help me to install this as I also want buy django course....
Pls help me in this

[@prithvirajsingh6979]

Thanku so much .

[@stevemarshall2358]

Thank you

[@aniketchatterjee6603]

Love you sir

[@vanshvashishtha]

katai jeher sirrrrrrrr BINOD.....

[@MdAbid-dr2nw]

great video sir

[@Pujari0320]

Thank u Sir ji 😘

[@creationofislam]

Thank you sir

[@aj-lan284]

Please make one webcast on PATENT registration and all stuffs related to this!!

[@parleg759]

Love from bhopal

[@sohailakhtar7932]

Gud Evening Sir... Sir I am learning Python tutorial provided by you and I have learnt python in the most simple and efficient way because of u sir.... I am thanking u from core of my heart sir.... thanks a lot

[@uditkapadia7104]

Can you upload video of crud operations with python.

[@ravi_sorathiya]

Isn't better to use xampp for that better compare to mysql havey stuff?

[@imaadi20]

I've got a data entry software I want that data store in online how it will work can you help me please. I'm using python language for that software. can you tell me the procedure? I'm waiting....

[@vasugarg862]

sir please upload a video on how to install mysql python connector and database

[@JavaAidTutorials]

Nice video..

[@sohailakhtar7932]

Atleast make a explanation video on Python data structure sir as how to learn serialwise...

[@computerworld2861]

Sir error is occurring
unknown character set: 'utf8mb4'.
I have installed mysql and installed mysql python connector. Only thing is port address was 3306 saying its already in use...so i changed it to 3307.
So guide me sir what should I do .. resolve this issue. Thank you...

[@animeshsingh3372]

can any tell me why this problem happen
"Not all parameters were used in the SQL statement")
mysql.connector.errors.ProgrammingError: Not all parameters were used in the SQL statement

[@manish5.052]

thanku sir

[@himanshinagi6392]

Python and mySQL phone per instol kar SK tqec h? Sir

[@saurabhsharma9665]

Sir thank u
plz. Android and Database m Connectivity pr bhi kuch video free publish kigiyega..
Thank you sir....

[@kaushalkumartechie2856]

thnx sir

[@mavihstricks9457]

Sir ek calendar Wala simple program bna do in c language please sir .just me to be year Dale wo print ho jaye

[@HelloWorld-to8fn]

Sir please upload testing releted video and courses

[@skynetwork2738]

Thnks sir

[@punk77777]

Sir, please make a video series of python tutorial.

[@RaviRavi-mj1le]

Already available

[@pinakiprasannadas8567]

He is asking for free course.

[@raushankumar-qg3jo]

Please help me any body.
At 7:01 .
We get out put " no module named 'mysql'.
Sir how can i solve it.

[@kbinumathew]

How to connect python to a mysql database in a website, please do a tutorial...

[@saquibahmed6798]

sir please JDBC pe ek video upload kijiye

[@KGLEGENDS]

Sir , 💝💝💝

[@BhaktiPrem851]

dynamic business central ki development ki series bi bano sir g please

[@sharmanihal99]

Prepare to get overwhelmed by knowledge.

[@Travel.Omu365]

How can I develop database and publish for people

[@VivekSingh-xu5xb]

hey sir whenever i am trying to execute this code it is showing "10061 No connection could be made because the target machine actively refused it" this error.

[@sanketsuryawanshi]

Same problem

[@cyrusgracias4556]

Please show python db connectivity using MS SQL Server database

[@mridul1161]

Sir full stack pe banaye video

[@ans7452]

What is sqllite in python ? Used as mysql

[@LAWSAURABH]

Sir Kisi bhi program ko application aur software main kaise convert karte hai uska video banao... please

[@jitendrajadav6877]

How connect oracle db and orange ide

[@Sreekanth_yes]

Bro no module named mysql.connector shows... please solve

[@saurabhbarasiya4721]

Sir ye kitne video ki series h

[@thanudasb5526]

Sir Which version of python and mysql to be installed in windows 7 32 bit.

[@sudiptasharma3005]

python version 2.7 mySQL i dunno

[@vikmanmh13]

सर java project life cycle पर एक video जरुर बनाइए

[@arunastutorialpoint]

Sir bina internet connection kai python connectivity possible nahi hai kya?

[@ramakantvishwakarma2330]

mysql.connector.errors.ProgrammingError: 1045 (28000): Access denied when i try to connect server db . instead of local. can you help me here ??

[@CS_Guide_collegeExam_Ugc_gate]

Sir MongoDB with python hojayega??

[@dancegirlradhika6010]

Sir agr hum password bhul gye h to kya connection stablish nai kr sakte. .........password change nai kr sakte

[@sarthakaggarwal7809]

Sirandroid development bhi bnao

[@HemantKumar-qr6dr]

Hello sir i like your videos too much because your way of teaching is awesome. now a days i am watching your c language tutorial videos. for more practice. i need a practice book. will it will be helpful for me, if yes so which book i should buy it is my first programming language. while practice i have to thought many program which is good but now but it is time for practice not for thinking program. please suggest me .
thank you very much

[@riturajshrivastava3386]

Hello sir! is there any paid course for oracle/mysql?if not when will you create it? I am eagerly waiting to learn sql.

[@mathsloading6801]

You can go to W3 schools and learn from there.

[@findingyou6905]

sql installed. pip sql installed. when we apply code then it shows more errors in line number 2 ,,, at the end it says the/__init__ in connect

[@rockingsurya4993]

same error bro

[@ganeshgunjal4220]

NotSupportedError: Authentication plugin 'caching_sha2_password' is not supported..
plz help

[@mohsinimam2048]

4 silver play buttons 😅
Wow ! 🤩

[@Ramandeepsingh-ul3ws]

Sir my python shell is saying invalid syntax

[@shubhamagarwal390]

not working this this method...
mysql.connector.errors.NotSupportedError: Authentication plugin 'caching_sha2_password' is not supported

[@shreyashibansal7431]

same

[@vinitraj119]

Sir Germany par video banao software engineer plzz

[@vickysharma9227]

sir ji,error aa rha h......
NotSupportedError: Authentication plugin 'caching_sha2_password' is not supported
please try to help me out!

[@Shadow-es5hf]

i am also getting same error

[@usmanisyed2168]

Sir I'm new to your channel. Can you tell me about MCA through distance learning. If you have already made a video help me by sharing the link.

[@siddharthGupta632]

Better go for certification courses than MCA.

[@renymathew8302]

Sir,still it is showing error
"InterfaceErrro:2003: can't connect to MySQL server on localhost:3306"
Sir pls help🙏

[@zakriabacha2477]

Bro first start the xampp, and then start your apache server and MYSQL in xampp. THEN IT WILL RUN.

[@satyampandey8650]

Same problem, pls tell the solution

[@anjalibarfa1521]

Sir mere pass mysql install nhi he mere pass Oracle install he to Oracle se ho jayega kya?

[@arvindkumargogna7571]

I am having problem while running your code help me

[@ankitkumarsrivastava9750]

sir my connection has dns error

[@kamleshkumar-tg5sw]

Sir when I create database it show
Programming error SQL syntax😥 how to solve 😭😭😭

[@sulemanahmadkhan1790]

Hi sir

[@ritikmathur2287]

Sir error show kr rha hai yh
ModuleNotFoundError: No module named 'mysql'
Kya kreh sir plzz tell me

[@shlokrajpoot8385]

Same problem

[@palakmundra91]

Same problem I am facing

[@minalkumrawat1386]

Sir... Mere pc m nhi ho rha hai... Bar bar rk error show ho rhi h.... Can't connect to mysql server on 'local host:3306

[@watchalltricks4811]

MySQL 8.0 wala meray pas nahi aa rah drivers install karnay k bad plzz help

[@dancegirlradhika6010]

Sir password jo apne enter kiya h bo kb banate h

[@Himanshu-ef7mh]

Legends connecting in 2021😊

[@all_techz]

Sir ap saurab shukla hai na jinone cpp pe playlist bnaiye hai saurab shukla naam ke server pe

[@mysirgdotcom]

Yes

[@nikdevops]

MYSQL-python is not working mysqlclient is working as wrapper for it.

[@sudipnayek5340]

Sir iss course free me lega?

[@B-OMPRAKASHBHAWARLALCHOUDHARY-]

it not okk
if it bad fpor mysql

[@sliceofart1862]

Sir output nhi aa rha h

[@01utpalraj95]

Sir maine krr liya fir bhi error aa raha hai sir plz mujhe project dena hai bata dijiye