How to extract a variable from a SQLite database?

Question

Python

How can I pull in a variable from a SQLite database?
Code example:

import sqlite3 as sql

conn = sql.connect('database.db')
cur = conn.cursor()

cur.execute("""CREATE TABLE IF NOT EXISTS test(test_int INT)""")
conn.commit()

print(test_int) #Нужно вывести переменную test_int из базы данных

Answer 1

open SQL textbook and learn

Answer 2

import sqlite3
db = sqlite3.connect('database.db')
cur = db.cursor()
a = str(cur.execute('SELECT column_name FROM table_name WHERE id = row_id').fetchone()[0])
print( a)

Answer 3

test_int INT is not a variable here, but the name of a column in the test table, where records of the int type are stored. So far it hasn't written anything.

Answer 4

The database has no variables. There are tables. These are rows and columns. Insert lines, read lines. Then think for yourself.
Read books, study.