SQL: Insert multiple sets of values in one statement?

Question

Is it possible to insert multiple sets of values to a SQLite table in one statement?

I was trying:

INSERT INTO the_table VALUES (1,2,'hi'),(2,0,'foo');

with the different ()s representing different insert sets, but I get an error.

Answer 1

Are there only three columns in your table? If not, you could try defining the column names you are setting like so:

INSERT INTO the_table 
       (column1  ,column2  ,column3) 
VALUES (1        ,2        ,'hi'   )
      ,(2        ,0        ,'foo'  )

This convention was introduced in SQL Server 2008 known as the Table Value Constructor. See MSDN's INSERT page for a look at the overall syntax. Also, the INSERT statement can be easily formatted for better readability.

Answer 2

You can do

INSERT INTO the_table 
SELECT 1,2,'hi'
UNION
SELECT 2,0,'foo';