> Le 2 août 2019 à 10:04, Luca Ferrari <fluca1...@gmail.com> a écrit : > > 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);
Besides the other answers focused on using .mode insert more precisely, the .dump command might prove useful too. — Best Regards, Meilleures salutations, Met vriendelijke groeten, Mit besten Grüßen, Olivier Mascia https://www.integral.be _______________________________________________ sqlite-users mailing list sqlite-users@mailinglists.sqlite.org http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users
