On 11 October 2012 15:07, Alan Frankel <alan.fran...@mathworks.com> wrote: > I have a table that uses an autogenerated id as primary key. I want to do > bulk inserts using UNION SELECT, but it doesn't seem to be happy unless I > specify an id for each row: > > sqlite> create table CelestialObject (id INTEGER PRIMARY KEY, name > VARCHAR(25), distance REAL); > sqlite> insert into CelestialObject select 'Betelguese' as name, 200 as > distance UNION SELECT 'Procyon', 500; > Error: table CelestialObject has 3 columns but 2 values were supplied > > If I specify AUTOINCREMENT for the id (i.e., "id INTEGER PRIMARY KEY > AUTOINCREMENT") when I create the table, the error is the same. Can anyone > tell me whether there's a way to use a bulk insert without specifying an id > for each row?
insert into CelestialObject( name, distance ) select 'Betelguese' as name, 200 as distance UNION SELECT 'Procyon', 500; > > Thanks, > Alan > Regards, Simon _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users