关于merge表的问题

Danielle1206

我在建立merge表时遇到了以下一些问题,
我先建立了两个表,如下:mysql>; create table sales_rep1(
    ->; id int auto_increment primary key,
    ->; employee_number int(11),
    ->; surname varchar(40),
    ->; first_name varchar(30),
    ->; commission tinyint(4),
    ->; date_joined date,
    ->; birthday date
    ->; ) type=myisam;
Query OK, 0 rows affected (0.11 sec)

mysql>; create table sales_rep2(
    ->; id int auto_increment primary key,
    ->; employee_number int(11),
    ->; surname varchar(30),
    ->; first_name varchar(30),
    ->; commission tinyint(4),
    ->; date_joined date,
    ->; birthday date,
    ->; time date) type=myisam;
Query OK, 0 rows affected (0.06 sec)

然后建立了merge表.

mysql>; create table sales_rep1_2(
    ->; id int auto_increment primary key,
    ->; employee_number int(11),
    ->; surname varchar(40),
    ->; first_name varchar(30),
    ->; commission tinyint(4),
    ->; date_joined date,
    ->; birthday date) type=merge union=(sales_rep1,sales_rep2);
Query OK, 0 rows affected (0.06 sec)
我试图往sales_rep1里添加数据,省去了id 列...但是出错了,不知道为什么.
mysql>; insert into sales_rep1 ('employee_number','surname','first_name','commission','date_joi
ned','birthday') values (
    ->; 1,'Tshwete','Paul',15,'1999-01-03','1970-03-04');
ERROR 1064: You have an error in your SQL syntax.  Check the manual that corresponds to your M
ySQL server version for the right syntax to use near ''employee_number','surname','first_name'
,'commission','date_joi

于是,我加上了id列,成功了.
mysql>; insert into sales_rep1 values(1,1,'Tshwete','Paul',15,'1999-01-03','1970-03-04');
Query OK, 1 row affected (0.02 sec)
然后我给sales_rep2添加了数据.
mysql>; insert into sales_rep2 values(1,2,'Grobler','Peggy-Sue',12,'2001-11-19','1956-08-25');
Query OK, 1 row affected (0.00 sec)
然后试图查看merge表的数据,但是无法打开,为什么呢?哪位高手帮忙看一下?
mysql>; select * from sales_rep1_2;
ERROR 1016: Can't open file: 'sales_rep1_2.MRG'. (errno: 143)