Python and MySQL - Selecting and Getting Data

A series of Python Tutorials covering all the basics of Python and MySQL. This video will cover selecting and getting data from our table in MySQL.

♦♦♦♦♦♦♦♦♦♦

THECODEX is a company focused on empowering and enabling anyone to learn how to code. Established in 2015 by Avinash Jain, THECODEX has taught over 175,000 students around the world how to code. With over 15 programming courses on a wide variety of topics, and more than 10,000 5-Star reviews, THECODEX is the right choice for you.

We provide engaging and comprehensive videos that break down complex information and cover everything you need to know about the subject. All students get access to our Q/A forums where you can get your doubts and problems cleared up. At the end of every course, you will receive a certificate of completion.

Jumpstart your Coding Journey with THECODEX today!

♦♦♦♦♦♦♦♦♦♦

Music: Flash Funk (Marshmello)

[truthhonestman]

I like the way you are talking fast. Excellent and clear explanation. Thanks

[Haku_Hatake]

Awesome dude, simply awesome!! I was trying to figure out how to display data from a database into a label(so it can be seen by the user) This works great! Now I just need to figure out how to clean up the results and we are all

[MANISHSHARMA-xksu]

LOVE FROM INDIA...LOVED YOUR VIDEOS....:-)

[tobeqz]

I love Python mysql syntax so much. I switched over from PHP and have you seen MySQLi syntax? It looks horrendous and this is just so unbelievably clean. Thanks for the tutorial.

[celeste]

Thank you for the amazing classes!!! Congratulations! It is helping me a lot!!!

[djpatronrussia]

Thx a lot)))) Great!!!! Simple and very usefull!

[yoniziv]

Love your videos!
small question, How can I set pycharm to highlight sql syntax like in your examples (the reserved sql words in blue color...) tried to look for solution in the pycharm preferences but with no success

[vlak-gaming]

how do I output these selected rows in Html?

[nishantpiyush]

hello sir, i need to kill id which is running >3000sec how do i do it using python

[chintanbhuta]

I am using mysql database while retrieving the data i m getting error as failed Parsing EOF packet. Any idea regarding what is the error about

[anitayadav]

Sir how can we get the output in tabular for? Like
Rollno Name Marks Gender
01 Rohan 70 M
02 John 80 M
03 Rani 95 F
Like this in python?

[sarthaksrivastava]

hey, I need help !! while printing the results it always gets printed with brackets with a comma at the end . how can I remove that?

[lonewolfcoding]

it is possible to compute data from database and store it back?
because im creating a normal balance system using tkinter please give me the simple codes

[dhruvtandel]

What if I want the data in string form instead of tuple

[Kennerdoll]

What if i want to save the age values in an variable ages =[], how do i go about it?

[codebot]

can u tell me how to extract from user defined data?

[merowe]

it works without is it necessary to include that

[fantabarack]

Hey Buddy, do you have any tutorial for using python for rest api implementation?

[hasnatmanzoor]

please someone tell me why does it dont work with the jupyter notebooks

[dikshavasudev]

Great Playlist.
I have one question. We can iterate over the mycursor directly to print the selected rows, is there any specific advantage of using fetchall()/fetchone().