J
J
Johnem2020-03-28 20:53:57
Python
Johnem, 2020-03-28 20:53:57

How to do multiple substitution of values ​​in a Sqlite query?

Here is an example of a single substitution

cursor.execute("""INSERT INTO flow_of_funds VALUES (:input_date_and_time, 'RUB', 'crediting funds', '22950')""", {"input_date_and_time": input_date_and_time})

Answer the question

In order to leave comments, you need to log in

1 answer(s)
W
Wwwoper, 2020-03-28
@Johnem

cursor.executemany https://docs.python.org/2/library/sqlite3.html

Didn't find what you were looking for?

Ask your question

Ask a Question

731 491 924 answers to any question