How to place the value of an input inside a "cell" of a SQLITE3 table, with Python?

Question

Hello, I’m a beginner in programming and, learning about the SQLITE3 library, in Python, I came across a problem and even after a lot of research I did not find the solution. I would like to be able to record in the table a value referring to only one cell of the table, and not the Row whole. For this, I would have to indicate the column and id of the Row, right?

Here is the code (table, cursor, connect, everything is already done in the code):

def data_entry():
  paciente = str(input('NOME DO PACIENTE = ')).lower()
  dia = str(input('DIA = '))
  horario = str(input('HORÁRIO = '))
  cursor.execute('INSERT INTO agendajulho {} ({}) VALUES (?)'.format(dia, horario), (paciente))
  connect.commit()

Anyway, if you could help me, I’d be very grateful.

Answer 1

In this post Regis explains how to work with Sqlite database.

http://pythonclub.com.br/gerenciando-banco-dados-sqlite3-python-parte1.html