1

In my SQLite I want to insert 2 rows.

INSERT INTO notification_invoice (amount,currencyISOCode) VALUES
 (1.1,'498'),
 (34.2,'980');

But I get error:

30-Nov-18 12:21:21: SQL Error: near ",": syntax error INSERT INTO notification_invoice (amount,currencyISOCode) VALUES (1.1,'498'), (34.2,'980'); >

Cœur
  • 37,241
  • 25
  • 195
  • 267
Alexei
  • 14,350
  • 37
  • 121
  • 240
  • What DB engine do you use? Terradata? – juergen d Nov 30 '18 at 10:24
  • I use DB: SQLite – Alexei Nov 30 '18 at 10:59
  • 1
    @Alexei Which version? It looks like you run sqlite 2 while the syntax you use for multiple line inserts is only supported since sqlite 3.7. – sloth Nov 30 '18 at 11:09
  • @sloth Yes, you was right. After I update sqlite drivers - it's work. – Alexei Nov 30 '18 at 11:25
  • 1
    Possible duplicate of [Is it possible to insert multiple rows at a time in an SQLite database?](https://stackoverflow.com/questions/1609637/is-it-possible-to-insert-multiple-rows-at-a-time-in-an-sqlite-database) – sloth Nov 30 '18 at 11:31

0 Answers0