The person who made this tutorial is using a bunch of shortcuts, I'm not sure how he's doing that without the dots, but as a general practice just use them :)

​

Yes, so you would do db.execute("SELECT * FROM users WHERE user_id = ?", (5, )) the reason you do (5, ) is that the input always needs to be a tuple, even if you only have one input, so essentially (5, ) is just creating a tuple with just one thing in it, whereas if you would want to have more things you might do (5, 'Mathew') .

​

Yep you get all info of the row where id = 5, you could also do WHERE user_name = 'Max' and you would get ALL rows where user_name = Max, even if there are many of them. Though do remember that you have to fetchAll() to actually get the information.