sql
m0_60201553
这个作者很懒,什么都没留下…
展开
-
SpringCloud接入Sentinel
1、引入依赖包 <dependency> <groupId>com.alibaba.cloud</groupId> <artifactId>spring-cloud-starter-alibaba-sentinel</artifactId> </dependency> 2、下载客户端原创 2021-07-22 09:17:44 · 104 阅读 · 0 评论 -
registry.conf
registry { # file 、nacos 、eureka、redis、zk、consul、etcd3、sofa type = "nacos" nacos { application = "seata-server" serverAddr = "127.0.0.1:8848" group = "SEATA_GROUP" namespace = "" cluster = "default" username = "" password...原创 2021-07-21 16:49:50 · 422 阅读 · 0 评论 -
seata file.config配置
## transaction log store, only used in seata-server store { ## store mode: file、db、redis mode = "db" ## file store property file { ## store location dir dir = "sessionStore" # branch session size , if exceeded first try compress lockk...原创 2021-07-21 16:25:33 · 960 阅读 · 0 评论 -
seata 建表语句
-- -------------------------------- The script used when storeMode is 'db' -------------------------------- -- the table to store GlobalSession data CREATE TABLE IF NOT EXISTS `global_table` ( `xid` VARCHAR(128) NOT NULL, `tra...原创 2021-07-21 16:23:24 · 809 阅读 · 0 评论 -
mysql json类型
INSERT INTO `test` (`id`, `test_json)VALUES('1','{"deptId":"c6d7cb4deeac411cb3384b1b3 a1278596", "workNo":"00001", "post":"test"}'); 查询: WHERE test_json-> '$.companyId' = '1300265503642865665'; test_json->> '$.workNo' workNo, ...原创 2021-07-21 16:13:10 · 45 阅读 · 0 评论