qq_35968173的博客

在docker中配置mysql主从复制。

【代码】MySQL锁相关语句和操作。

建表语句CREATE TABLE `tb_score` ( `id` BIGINT(18) NOT NULL AUTO_INCREMENT, `name` VARCHAR(20) DEFAULT NULL, `class` VARCHAR(10) DEFAULT NULL, `score` INT(5) DEFAULT NULL, PRIMARY KEY (`id`)) ENGINE=INNODB AUTO_INCREMENT=17 DEFAULT CHARSET=utf8;IN

SELECT @row := @row + 1 AS row FROM(select 0 union all select 1 ) t1,(select 0 union all select 1 union all select 2 union all select 3 union all select 4 union all select 5 ) t2,(SELECT @row:=0) r1