eng Yu
>Sent: Friday, 6 September, 2019 18:09
>To: SQLite mailing list
>Subject: Re: [sqlite] Merge two sqlar files
>
>OK. It works. But it seems that `.ar` is not necessary.
>
>import sqlite3
>infile1, infile2, outfile = sys.argv[1:]
>conn=sqlite3.connect(outfil
a lot about anticipated traffic volume.
> >
> > >-Original Message-
> > >From: sqlite-users On Behalf
> > >Of Peng Yu
> > >Sent: Friday, 6 September, 2019 17:04
> > >To: SQLite mailing list
but only a Stairway to Heaven says a
> lot about anticipated traffic volume.
>
> >-Original Message-----
> >From: sqlite-users On Behalf
> >Of Peng Yu
> >Sent: Friday, 6 September, 2019 17:04
> >To: SQLite mailing list
> >Subject: [sqlite] Merge two sqla
OK. It works. But it seems that `.ar` is not necessary.
import sqlite3
infile1, infile2, outfile = sys.argv[1:]
conn=sqlite3.connect(outfile)
c=conn.cursor()
c.execute('ATTACH DATABASE ? AS d1', [infile1])
c.execute('ATTACH DATABASE ? AS d2', [infile2])
c.execute('CREATE TABLE sqlar AS SELECT *
a Stairway to Heaven says a
lot about anticipated traffic volume.
>-Original Message-
>From: sqlite-users On Behalf
>Of Peng Yu
>Sent: Friday, 6 September, 2019 17:04
>To: SQLite mailing list
>Subject: [sqlite] Merge two sqlar files
>
>Hi,
>
>UNION is for
Hi,
UNION is for tables in the same db file. Is there an easy command to
combine two sqlar files? Thanks.
https://www.sqlitetutorial.net/sqlite-union/
--
Regards,
Peng
___
sqlite-users mailing list
sqlite-users@mailinglists.sqlite.org
6 matches
Mail list logo