Mycat 运行与基础操作5

mysql> show tables;
+---------------+
| Tables_in_my4 |
+---------------+
| catworld4     |
+---------------+
1 row in set (0.00 sec)

mysql> desc catworld4;
+-------+-------------+------+-----+---------+-------+
| Field | Type        | Null | Key | Default | Extra |
+-------+-------------+------+-----+---------+-------+
| id    | int(11)     | NO   | PRI | NULL    |       |
| name  | varchar(30) | YES  |     | NULL    |       |
+-------+-------------+------+-----+---------+-------+
2 rows in set (0.00 sec)

mysql> show create table catworld4\G
*************************** 1. row ***************************
       Table: catworld4
Create Table: CREATE TABLE `catworld4` (
  `id` int(11) NOT NULL,
  `name` varchar(30) DEFAULT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1
1 row in set (0.00 sec)

mysql> select database();
+------------+
| database() |
+------------+
| my4        |
+------------+
1 row in set (0.00 sec)

mysql> 

mysql> insert into catworld4 values(1,"abc");
ERROR 1064 (HY000): partition table, insert must provide ColumnList
mysql> 

mysql> insert into catworld4(name,id) values("abc",1);
Query OK, 1 row affected (0.09 sec)

mysql> select count(*) from catworld4;
+--------+
| COUNT0 |
+--------+
|      1 |
+--------+
1 row in set (0.15 sec)

mysql> select * from catworld4;
+----+------+
| id | name |
+----+------+
|  1 | abc  |
+----+------+
1 row in set (0.04 sec)

mysql> insert into catworld4(name,id) values("abc",2);
Query OK, 1 row affected (0.04 sec)

mysql> insert into catworld4(name,id) values("abc",3);
Query OK, 1 row affected (0.01 sec)

mysql> insert into catworld4(name,id) values("abc",4);
Query OK, 1 row affected (0.00 sec)

mysql> insert into catworld4(name,id) values("abc",5);
Query OK, 1 row affected (0.01 sec)

mysql> insert into catworld4(name,id) values("abc",6);
Query OK, 1 row affected (0.01 sec)

mysql> insert into catworld4(name,id) values("abc",7);
Query OK, 1 row affected (0.01 sec)

mysql> insert into catworld4(name,id) values("abc",8);
Query OK, 1 row affected (0.04 sec)

mysql> insert into catworld4(name,id) values("abc",9);
Query OK, 1 row affected (0.01 sec)

mysql> insert into catworld4(name,id) values("abc",10);
Query OK, 1 row affected (0.03 sec)

mysql> select count(*) from catworld4;
+--------+
| COUNT0 |
+--------+
|     10 |
+--------+
1 row in set (0.05 sec)

mysql> select * from catworld4;
+----+------+
| id | name |
+----+------+
|  1 | abc  |
|  5 | abc  |
|  9 | abc  |
|  4 | abc  |
|  8 | abc  |
|  2 | abc  |
|  6 | abc  |
| 10 | abc  |
|  3 | abc  |
|  7 | abc  |
+----+------+
10 rows in set (0.03 sec)

mysql>