Re: looks like one database from the outside, but it's two inside

Sven Miller wrote:
And unfortunately I don't know enough about MySQL to be more helpful.
Database links may be an Oracle-only thing.

On 7/19/07, Theron Stanford <shixilun@xxxxxxxxx> wrote:
This sounds like a good idea. I guess I just don't know enough about
databases yet to know how to do this linking. Mostly I just know
about how to get DBI to interact with MySQL.


http://dev.mysql.com/doc/refman/5.0/en/create-view.html

create a view thus (from a quick scan on the doc)

create view my_agregate_table
as
select * from maintable
union
select * from tempdatatable


either or both of the selects can have where clauses that restrict the
data 'viewed'



--
This message has been scanned for viruses and
dangerous content by OpenProtect(http://www.openprotect.com), and is
believed to be clean.

.