Skip to main content
edited tags; edited title
Link
Super Kai - Kazuya Ito
  • 42.8k
  • 23
  • 258
  • 257

Is it possible How to insert multiple rows at a time in an SQLite database?

Question Protected by Jorgesys
Source Link
Andrew
  • 241.1k
  • 196
  • 531
  • 719

Is it possible to insert multiple rows at a time in an SQLite database?

In MySQL you can insert multiple rows like this:

INSERT INTO 'tablename' ('column1', 'column2') VALUES ('data1', 'data2'), ('data1', 'data2'), ('data1', 'data2'), ('data1', 'data2'); 

However, I am getting an error when I try to do something like this. Is it possible to insert multiple rows at a time in an SQLite database? What is the syntax to do that?