Read from (SELECT) Database table - SQLite3 with Python 3 part 3

preview_player
Показать описание
In the previous tutorials, we've covered creating a database and populating one, now we need to learn how to read from the database. Reading from a database is where the power of using something like SQLite over a flat file starts to make sense. While we can query the entire table, we can instead just query a single column, or even based on specific row values. Let's see what I mean

Рекомендации по теме
Комментарии
Автор

an old fellow that has forgotten how to code here! I recently decided to continue my career in data, im listening to your video like a podcast for refreshing my memory. Thank you for the great content man!

lotusincense
Автор

Dude, you are pure gold! My personal Python guru! Best explanations for python newbies! Keep up!

fixxxer
Автор

i was also expecting dynamic reading from database table while you using "SELECT" statement with WHERE clause


but you did great job here!

amarpanchal
Автор

I don't use to suscribe anyone, but you man, you gained another subscription with your awesome explanations. Please never stop posting.

daniellozanorojas
Автор

BEST tutorial! If we only had teachers like him around! ;-(

siddharthsonone
Автор

your cursor explanation made it so easy to understand Thanks!

taha
Автор

That SELECT explanation got you a new subscriber :) Very helpful stuff here.

janski
Автор

this is helping with my coding project a lot thank!

noahkelly
Автор

i just wanna point something that you've done: normally you would change the variable name 'data' to 'row' and then when you iterate through the rows you would say of course col[0] not row[0] so all the watchers can understand correctly

humancode
Автор

Enjoying your channel a lot - sentdex. Thank you!

kray
Автор

Good stuff! Your explanation is very clear and relatable!

adnanqz
Автор

Thanks a lot for your very interesting videos.
they are very useful and very interesting, I have learned Python very well and easy .

Compliments ! you are a very clever programmer and teacher.

All the best regards

Enrico from Italy

gordongekko
Автор

Thank you very much for this video! Really interesting and I like your analogy using the mouse cursor. Really helped me to understand :)

tymothylim
Автор

Bro your awesome! Learnt so much from your channel thus far

kelechiogudu
Автор

Perfect. Nothing else I could have asked for.
Thanks, can now finally do my student project now 🤣

nicholasyoa
Автор

My semister project is just possible beacuse of you ...subscribed:) :)

miniproject
Автор

0:34 (CTRL + '/') for PyCharm CE 2016

bart-uzi-yak
Автор

I love your videos and explanations, both in the Pygame tutorial series and this one. I do have two questions, though:
1) In general, why do you not write code using classes (OOP)?
2) What are we supposed to do with MySQL after 03:14:07 on 19 Jan 2038?

dp
Автор

your videos are very uesful to me .keep it up!

malaykumar
Автор

Very informative. Thank you very much.

ErrorAcctErrorAcct