Answer the question
In order to leave comments, you need to log in
Append list to sqlite3?
product = sql.execute(f"SELECT product FROM filter WHERE industry = ?", (industry,))
product = sql.fetchone()
product = list(product)
product.append(product_new)
sql.execute(f"UPDATE filter SET product = ? WHERE industry = ?", (product,industry,))
db.commit()
Answer the question
In order to leave comments, you need to log in
Didn't find what you were looking for?
Ask your questionAsk a Question
731 491 924 answers to any question