sqlite3.OperationalError: near "ON": syntax error

Asked Apr 29 '19 at 18:14

Active Apr 29 '19 at 18:14

Viewed 2,873 times

What is wrong with this SQL line? I've verified the types are correct.

c.execute('''INSERT into stock_table (item_name, stock, price) VALUES (?, ?, ?) ON DUPLICATE KEY UPDATE stock=VALUES(stock);''', (str(entry["name"]), int(entry["amount"]), float(entry["price"])))

asked Apr 29 '19 at 18:14

gannonbarnett

1,638
1
16
28

2

SQLite or MySQL? Depending on SQLite version, see this: https://stackoverflow.com/q/2717590/1422451 – Parfait Apr 29 '19 at 18:18
SQLite. Good catch, it looks like this functionality isn't supported by sqlite. – gannonbarnett Apr 29 '19 at 18:20
@Parfait could you comment a solution for sqlite? – gannonbarnett Apr 29 '19 at 18:21
Please see aforementioned linked answer with SQLite solutions. Also, please re-tag post with one DBMS. – Parfait Apr 29 '19 at 18:24
This error seems to occur on nix systems but not on windows. – Pedro Lobito Apr 27 '20 at 00:06

sqlite3.OperationalError: near "ON": syntax error

0 Answers0