Why not make it this way:
select 'database1', lists.* from database1.lists
union all
select 'database2', lists.* from database2.lists;
This way you will know exactly which lists persist in which database.
Pavel
On Sat, Aug 15, 2009 at 10:57 AM, Andrew Gatt wrote:
> Simon Slavin wrote:
>> On 15
On 15 Aug 2009, at 3:57pm, Andrew Gatt wrote:
> Simon Slavin wrote:
>> On 15 Aug 2009, at 3:12pm, Andrew Gatt wrote:
>>
>>> but by my scheme you can't be sure if the list_1 table exists in
>>> database2,
>>
>> Add a column to your 'lists' tables which says which database they're
>> part of. So e
Simon Slavin wrote:
> On 15 Aug 2009, at 3:12pm, Andrew Gatt wrote:
>
>
>> but by my scheme you can't be sure if the list_1 table exists in
>> database2,
>>
>
> Add a column to your 'lists' tables which says which database they're
> part of. So every row of the database will have the sam
Roger Andersson wrote:
>
> I have multiple databases, both have a table called "lists" inside this
> table is the names of other tables in the database that make up the lists.
> Each individual list is made up of the tables that have the same name in
> each database (the list is split between diffe
On 15 Aug 2009, at 3:12pm, Andrew Gatt wrote:
> but by my scheme you can't be sure if the list_1 table exists in
> database2,
Add a column to your 'lists' tables which says which database they're
part of. So every row of the database will have the same value.
Simon.
_
-users-boun...@sqlite.org] För Andrew Gatt
Skickat: den 15 augusti 2009 16:13
Till: General Discussion of SQLite Database
Ämne: [sqlite] Table Exists Query
Hi all,
I have multiple databases, both have a table called "lists" inside this
table is the names of other tables in the database that m
Hi all,
I have multiple databases, both have a table called "lists" inside this
table is the names of other tables in the database that make up the
lists. Each individual list is made up of the tables that have the same
name in each database (the list is split between different storage
devices in
7 matches
Mail list logo