How to print column value from sqlite in python?

Question

Python

Used this code

cur.execute("SELECT balance from users where userid = ?", (message.from_user.id,))

But as I was told, it outputs an array, not a value, as I would like

Answer 1

You just need to write the zero index of the array, this will be the value. for example

cur.execute("SELECT balance from users where userid = ?", (message.from_user.id,))
balance = cur.fetchone()
balance = balance[0]

First, we extract the first (it is the only) value, and then we take the zero index from it.