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

Channel:
United States sentdex
Subscribers:
1,410,000
Published on ● Video Link: https://www.youtube.com/watch?v=NCc5r7Wr7gg


Duration: 11:20
144,734 views
1,648

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

sample code and text tutorial: https://pythonprogramming.net/sqlite-part-3-reading-database-python/

Playlist: https://www.youtube.com/playlist?list=PLQVvvaa0QuDezJh0sC5CqXLKZTSKU1YNo

https://pythonprogramming.net
https://twitter.com/sentdex
https://www.facebook.com/pythonprogramming.net/
https://plus.google.com/+sentdex



Other Videos By sentdex


2016-01-30Database & Migrations - Django Web Development with Python 8
2016-01-28Blog View and Template - Django Web Development with Python 7
2016-01-26Beginning Blog - Django Web Development with Python 6
2016-01-24Passing variables from python to html - Django Web Development with Python 5
2016-01-22Bootstrap HTML CSS - Django Web Development with Python 4
2016-01-21Jinja Templating - Django Web Development with Python 3
2016-01-20Creating App - Django Web Development with Python 2
2016-01-19Introduction - Django Web Development with Python 1
2016-01-17UPDATE and DELETE - SQLite3 with Python 3 part 5
2016-01-17Graph from database table example - SQLite3 with Python 3 part 4
2016-01-17Read from (SELECT) Database table - SQLite3 with Python 3 part 3
2016-01-17Inserting variables to database table - SQLite3 with Python 3 part 2
2016-01-17Creating a database, table, and inserting - SQLite3 with Python 3 part 1
2016-01-11Haar Cascade for image & video object classification - OpenCV w/ Python for Image Video Analysis 21
2016-01-11Training Haar cascade object detection - OpenCV with Python for Image and Video Analysis 20
2016-01-11Cleaning images and creating description files - OpenCV with Python for Image and Video Analysis 19
2016-01-11Gathering Images for Haar Cascade - OpenCV with Python for Image and Video Analysis 18
2016-01-11Making your own Haar Cascade Intro - OpenCV with Python for Image and Video Analysis 17
2016-01-10Haar Cascade Object Detection Face & Eye - OpenCV with Python for Image and Video Analysis 16
2016-01-09MOG Background Reduction - OpenCV with Python for Image and Video Analysis 15
2016-01-08Feature Matching (Homography) Brute Force - OpenCV with Python for Image and Video Analysis 14


Tags:
python
sqlite
database
table
tutorial
sqlite3
select
read from