List:General Discussion« Previous MessageNext Message »
From:Eric Bergen Date:August 30 2004 5:07pm
Subject:Re: using two tables help
View as plain text  
If they are myisam tables you can use the merge storage engine.
http://dev.mysql.com/doc/mysql/en/MERGE.html


On Mon, 30 Aug 2004 09:58:48 -0700 (GMT-07:00), zeus@stripped
<zeus@stripped> wrote:
> Hi there,
> 
> I have multiple tables with identical structures, essentially current data and older
> data.  I want to query them as if they were a single table.  How can I do this?  I would
> like to be compatible with mysql 3.23.xx.  Many thanks!
> 
> -Bob
> 
> --
> MySQL General Mailing List
> For list archives: http://lists.mysql.com/mysql
> To unsubscribe:    http://lists.mysql.com/mysql?unsub=1
> 
> 


-- 
Eric Bergen
eric.bergen@stripped
Thread
using two tables helpzeus30 Aug
  • Re: using two tables helpSGreen30 Aug
  • Re: using two tables helpEric Bergen30 Aug