SQLite Forum

Inserting multiple rows in table
Login
Running SQLite version 3.31.1 on Slackware-14.2 and trying to insert 2860
rows in the table. Each row has 12 fields, one for each column in the table,
yet sqlite3 complains:

$ sqlite3 testing.db < biota.sql
Error: near line 1: all VALUES must have the same number of terms

The first two lines of the file (wrapped to fit in here) are:

insert into Biota (sampid,site_id,sampdate,tclass,torder,tfamily,tgenus,
tspecies,subspecies,common_name,ffg,quant) values 

(1,11,'2000-07-18','Annelida','Oligochaeta','Tubificidae',null,null,null,null,
'Gatherer',22),

Twelve columns specified on the first line and 12 values presented in each
following line. (That's been checked.)

What am I missing?

Rich