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 |
Kafka进阶篇知识点
Kafka高级篇知识点
44个Kafka知识点(基础+进阶+高级)解析如下
由于篇幅有限,小编已将上面介绍的**《Kafka源码解析与实战》、Kafka面试专题解析、复习学习必备44个Kafka知识点(基础+进阶+高级)都整理成册,全部都是PDF文档**
如下**
[外链图片转存中…(img-HTXMKwls-1714422055598)]
由于篇幅有限,小编已将上面介绍的**《Kafka源码解析与实战》、Kafka面试专题解析、复习学习必备44个Kafka知识点(基础+进阶+高级)都整理成册,全部都是PDF文档**