我的数据库是mysql5.7,innodb,已提交隔离级别。我害怕死锁,所以我保持mysql sql语句简单,只有:
insert into ... where ...insert into ... where ... on duplicate key update每个sql将只有上面的一条语句。例如:连接exec insert into ... where ...;一次,永远不要执行多语句insert ... where ...; update ... where ...; where语句</e
它在READ_COMMITTED模式下以唯一的表运行,该表具有不重叠的主键和唯一的键: p BIGINT NOT NULL,mysql> SELECT * FROM information_schema.innodb_trx \G;
*************************** 1. row *-----------+------------+------------+-----------+----------+----