z394642048的博客

前置条件：[mysqld]server_id = 1log_bin = /var/log/mysql/mysql-bin.logmax_binlog_size = 1Gbinlog_format = rowbinlog_row_image = full使用条件：Python 2.7, 3.4+MySQL 5.6, 5.7安装binlog2sql前先安装git和pip：...

public class ParseSql { public static boolean check(String sql){ if(StringUtils.isEmpty(sql)){ return true; } sql = sql.toLowerCase(); String badStr ...

例如，当topicId相同时，查询bookStatus为2所在行的数据，若不存在，则查询bookStatus为1中missionId最大所在行的数据。SELECT rm.id missionId, rm.cover, rm.mission_type bookStatus, rm.`name`, DATE_FORMAT( rm.end_time, '%Y-%m-%d %H:%i:%s...