Mysql

docker-mysql docker-compose.yml

version: "3.1"
services:
  mysql:
    restart: always
    image: daocloud.io/library/mysql:5.7.4
    container_name: mysql
    ports:
      - 3306:3306
    environment:
      MYSQL_ROOT_PASSWORD: root
      TZ: Asia/Shanghai
    volumes:
      - /docker/mysql/mysql_data:/var/lib/mysql

🛎️canal

常规操作

细节

测试代码

start transaction;

select sleep(10),aftermarket_order_log.* from aftermarket_order_log where aftermarket_code="12" for update;

start transaction;

select sleep(10),sheet1.* from sheet1 where asro_code="111" for update;

start transaction;

UPDATE sheet1 SET asroab_firstname = 222 WHERE asro_code = '1111';

start transaction;select sleep(10),sheet1.* from sheet1 where asro_code="111" for update;COMMIT; start transaction;UPDATE sheet1 SET asroab_firstname = 222 WHERE asro_code = '222';COMMIT;

省份

# Mysql

Mysql