On Fri, Aug 2, 2019 at 12:03 PM Olivier Mascia wrote:
> Besides the other answers focused on using .mode insert more precisely, the
> .dump command might prove useful too.
Yes, but dump will dump all the columns, including autoincrement, that
is something I want to avoid in the final output.
Th
On Fri, Aug 2, 2019 at 10:17 AM Dan Kennedy wrote:
>sqlite3> .headers on
Yes, but I forgot to mention that I'm using sqlite 3.7.17 (back from
2013), so this option is not working.
However, since I've tested it works on recent versions, I think I
would copy all the databases on a machine with
> Le 2 août 2019 à 10:04, Luca Ferrari 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;
> INSE
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(20
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 t
5 matches
Mail list logo