创建的子表 :xx可以替换成具体的值 ENGINE = MyISAM; 一定要写
- CREATE TABLE log_xx
- (
- dt DATETIME NOT NULL,
- info VARCHAR(100) NOT NULL,
- INDEX (dt)
- ) ENGINE = MyISAM;
- 创建的主表:
-
- CREATE TABLE log_merge
- (
- dt DATETIME NOT NULL,
- info VARCHAR(100) NOT NULL,
- INDEX(dt)
- ) ENGINE = MERGE UNION = (log_2004, log_2005, log_2006, log_2007);
查询直接查询log_merge表即可
select * from log_merge
对于后续增加的子表:
- CREATE TABLE log_2009 LIKE log_2008;
- ALTER TABLE log_merge
- UNION = (log_2004, log_2005, log_2006, log_2007,log_2008,log_2009);