先锁定 lock tables froadpoints.points_account read
发多个请求
解锁 unlock tables
解锁 unlock tables
事务处理方法用事务加数据库锁处理。
查看死锁语句
show engine innodb status
LOCK TABLES `t_account_info` WRITE;
INSERT INTO `t_account_info` VALUES
UNLOCK TABLES;