Don't knwo if you want to see the results from all tables in one row (join)
or results from all tables as multiple rows (union) I'd think that if the
timestamps were similar, order by with UNION would give something like you
need?
A vague idea of the concept would help.
On Fri, Jul 17, 2015 at
On 17 Jul 2015, at 5:27pm, Hayden Livingston wrote:
> Sorry, they do not have the same definition. They are different
> definitions. I just want to view the data in a view such that all rows
> from all tables can be seen sorted by time.
You have designed 600 to 800 different table definitions
> I have multiple tables of data already, say TableA, TableB. These tables have
> different representations, one may contain a TEXT column, the other may
> contain and INTEGER column, but all of them contain an INTEGER field called
> time, which is unique.
I don't understand your
On 17 Jul 2015, at 3:22am, Hayden Livingston wrote:
> So, In my application code I'm going to through loop through all the
> tables. The table count is usually high hundreds (~600-800)
Why do you have so many tables which, if I understand your post right, have the
same column definitions ?
Heh, each source defines their own table definition, and they do
match sometimes, but sometimes they don't.
People don't always query their columns, they usually just go find
string in column, so I see your point, believe me. The programmer in
me says what if they need to query > X ... then I'll
Sorry, they do not have the same definition. They are different
definitions. I just want to view the data in a view such that all rows
from all tables can be seen sorted by time.
Obviously SQLite cannot do this since the table definitions are
different, and I'd have to write some application
On Thursday, 16 July, 2015, 21:50, Hayden Livingston said:
> Thanks, Keith for correcting my usage.
> I'm referring to tables when I mean database schema, so pardon my
> technical terminology.
> I have multiple tables of data already, say TableA, TableB. These
> tables have different
> I have different schema data that I'd like to store across tables, and
> it is sorted in chronological order.
Please explain what you mean by "schema", and especially "schema data". In a
relational database there is only one schema per database. This single schema
describes the tables and
Thanks, Keith for correcting my usage.
I'm referring to tables when I mean database schema, so pardon my
technical terminology.
I have multiple tables of data already, say TableA, TableB. These
tables have different representations, one may contain a TEXT column,
the other may contain and
I have different schema data that I'd like to store across tables, and
it is sorted in chronological order.
But then I also want to be able to make queries across tables when I
do a query that says after time X, I want it to show me all rows --
obviously different schema doesn't make this
10 matches
Mail list logo