MyCat：第六章：MyCAT自增字段和返回生成的主键ID的经验分享

`nm` INT(10) UNSIGNED NOT NULL,

PRIMARY KEY (`id`)

) ENGINE=MYISAM AUTO_INCREMENT=6 DEFAULT CHARSET=utf8;

2、mycat定义自增

[root@test conf]# vim schema.xml

<?xml version="1.0"?>

<mycat:schema xmlns:mycat=“http://org.opencloudb/”>

select user()

</mycat:schema>

3、mycat对应sequence_db_conf.properties增加相应设置；

4、mycat的对应mycat_sequence增加对应记录。

5、链接mycat，测试结果如下：

127.0.0.1/root:[TESTDB> insert into tt2(nm) values (99);

Query OK, 1 row affected (0.14 sec)

127.0.0.1/root:[TESTDB> select last_insert_id();

±-----------------+

| LAST_INSERT_ID() |

±-----------------+

|              101 |

±-----------------+

1 row in set (0.01 sec)

127.0.0.1/root:[TESTDB> insert into tt2(nm) values (99);

Query OK, 1 row affected (0.00 sec)

127.0.0.1/root:[TESTDB> select last_insert_id();

±-----------------+

| LAST_INSERT_ID() |

±-----------------+

|              102 |

±-----------------+

1 row in set (0.00 sec)

127.0.0.1/root:[TESTDB> insert into tt2(nm) values (99);

Query OK, 1 row affected (0.00 sec)

127.0.0.1/root:[TESTDB> select last_insert_id();

±-----------------+

| LAST_INSERT_ID() |

±-----------------+

|              103 |

±-----------------+

1 row in set (0.00 sec)

127.0.0.1/root:[TESTDB> insert into tt2(nm) values (99);

Query OK, 1 row affected (0.01 sec)

127.0.0.1/root:[TESTDB> select last_insert_id();

±-----------------+

| LAST_INSERT_ID() |

±-----------------+

|              104 |

±-----------------+

1 row in set (0.00 sec)

127.0.0.1/root:[TESTDB> insert into tt2(nm) values (99);

Query OK, 1 row affected (0.00 sec)

127.0.0.1/root:[TESTDB> select last_insert_id();

±-----------------+

| LAST_INSERT_ID() |

±-----------------+

|              105 |