On 2/8/62 15:04, Luca Ferrari wrote:
Hi,
I've got a lot of database files that I would like to dump using
INSERT statements.
unluckily, .mode insert does not work for me, or I'm not able to
understand how it works.
sqlite> select mude_anno, mude_numero from catdaemo;
INSERT INTO table VALUES(2019,1161);
My questions are:
1) why is the insert operating against "table" instead of the real
table I was selecting from (catdaemo)?
You can add a table name to the ".mode insert":
sqlite3> .mode insert catdaemo
2) is there a way to force the INSER to have also the columns I
selected listed? I would like something like:
INSERT INTO catadaemo( mude_anno, mude_numero ) VALUES(2019,1161);
Try doing:
sqlite3> .headers on
along with the ".mode insert" command.
Dan.
_______________________________________________
sqlite-users mailing list
sqlite-users@mailinglists.sqlite.org
http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users