Python and Databases 5 - SQLite3 - Using Variables with Queries

Let's see how we can use host variables instead of inserting arbitrary values into the SQL before it is parsed and how it avoids injection attacks.

We will learn how to use named and positional parameters in our Python scripts.

------

----

----
Schedule: New educational videos every week
-----

Learn Something New:
------
-----
Learn Something New:
------

[karramsos]

Let's use variables with our SQLite3 database and Python :-)

[dedeokoro]

Do you know how to select data using an and statement where both criteria require a variable?

[mrphysh]

How would I use a variable in a [SELECT....FROM .. WHERE ] statement. To be a little more specific; I want to search the sqlite3 database using the datetime.datetime stamp, but iterate through different days (for example) (the variable is in the WHERE field) (good video)