mysql分区表性能问题
我有一个统计表，包含帐号、业务数据以及日期字段，数据量会比较多，而且大多数查询条件是帐号以及时间段。
我建立两个测试表，一个分区，一个不分区。
分区函数用如下形式：
SQL code:
PARTITION BY RANGE (datediff(settledate,'2008-05-31'))
(PARTITION p0806 VALUES LESS THAN (30) ENGINE = InnoDB,
PARTITION p0807 VALUES LESS THAN (61) ENGINE = InnoDB,
PARTITION p0808 VALUES LESS THAN (92) ENGINE = InnoDB,
PARTITION p0809 VALUES LESS THAN (122) ENGINE = InnoDB,
PARTITION p0810 VALUES LESS THAN (153) ENGINE = InnoDB,
PARTITION p0811 VALUES LESS THAN (183) ENGINE = InnoDB,
PARTITION p0812 VALUES LESS THAN (214) ENGINE = InnoDB,
PARTITION p0901 VALUES LESS THAN (245) ENGINE = InnoDB,
PARTITION p0902 VALUES LESS THAN (273) ENGINE = InnoDB,
PARTITION p0903 VALUES LESS THAN (304) ENGINE = InnoDB,
PARTITION p0904 VALUES LESS THAN (334) ENGINE = InnoDB,
PARTITION p0905 VALUES LESS THAN (365) ENGINE = InnoDB,
PARTITION p0906 VALUES LESS THAN (395) ENGINE = InnoDB,
PARTITION p0907 VALUES LESS THAN (426) ENGINE = InnoDB,
PARTITION p0908 VALUES LESS THAN (457) ENGINE = InnoDB,
PARTITION p0909 VALUES LESS THAN (487) ENGINE = InnoDB,
PARTITION p0910 VALUES LESS THAN (518) ENGINE = InnoDB,
PARTITION p0911 VALUES LESS THAN (548) ENGINE = InnoDB,
PARTITION p0 VALUES LESS THAN MAXVALUE ENGINE = InnoDB)
然后两个表里面都插入400
相关问答：
我以前安装了一次，后来卸载了，现在再安装的时候，提示错误：Error 1305.Error reading from file C:DOCUME~1\LOCALS~1\Temp\mysql_server.msi.Verify that the file exists and that you can access it.
可是我找 ......
有一条sql语句 select a.name ,b.name from tableA a,tableB b where a.id = b.id and 。。。（其他过滤条件）
其中a.id 为tableA主键 有唯一性索引 数据量才1千多
b.id 为日志表tableB 的外键 ，慢去条件的才 ......
mysql>create book(
->id varchar(20) not null,g
->
以上是在mysql命令行里的操作
在上面中我在倒数第二行多打了一个字母g然后按了回车键，请问从倒数第一行怎么 ......
建表：插记录
SQL code:
create table tablename (id int,RQ1 datetime,RQ2 datetime)
-- select * from tablename
insert into tablename
select 1,'2009-01-01 10:00:00','2009-01-02 11:00:00' union
......
