sqlite3.OperationalError: near "I": syntax error code example
Example 1: sqlite3.OperationalError: near "7": syntax error
cur.execute('INSERT INTO "{}" VALUES(?, ?)'.format(group.replace('"', '""')), (food, 1))
Example 2: sqlite3.OperationalError: near "7": syntax error
cur.execute('SELECT COUNT(Name) FROM "{}" WHERE Name=?'.format(group.replace('"', '""')), (food,))
Example 3: sqlite3.OperationalError: near "7": syntax error
cur.execute('UPDATE "{}" SET Times=? WHERE Name=?'.format(group.replace('"', '""')),
(times_before + 1, food))
Example 4: sqlite3.OperationalError: near "WHERE": syntax error
there shoudnt be a comma on the line before the WHERE clause ;)