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
  • 34,719
  • 24
  • 185
  • 251
Alexei
  • 11,572
  • 19
  • 87
  • 193
  • 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