处理因为docker时区问题使用到的sql语句

SELECT  *  FROM recy_bank_resume
SELECT  *  FROM recy_bank_resume WHERE update_resume_times<'2023-10-18 05:06:13'
AND  update_resume_times>'2023-09-01 05:06:13' ORDER BY update_resume_times DESC
SELECT  *  FROM recy_bank_resume WHERE id>261 AND id<271
UPDATE recy_bank_resume
SET update_resume_times=DATE_ADD(STR_TO_DATE(update_resume_times, '%Y-%m-%d %H:%i:%s'), INTERVAL 8 HOUR)
WHERE id>261 AND id<271

SELECT  COUNT(*)  FROM  sys_log 
SELECT  *  FROM  sys_log ORDER BY operate_time DESC
12843
13180
UPDATE your_table
SET your_column = DATE_ADD(STR_TO_DATE(your_column, '%Y-%m-%d %H:%i:%s'), INTERVAL 8 HOUR);
-- 12843
SELECT  *  FROM  sys_log WHERE operate_time='2023-09-24 11:42:49'
SELECT  *  FROM  sys_log WHERE  id=12843
SELECT  *  FROM sys_log WHERE id>12843 AND id<=13180

UPDATE sys_log
SET operate_time=DATE_ADD(STR_TO_DATE(operate_time, '%Y-%m-%d %H:%i:%s'), INTERVAL 8 HOUR)
WHERE id>12843 AND id<=13180

SELECT  *  FROM sys_log WHERE operate_time='2023-09-24 08:20:58'
-- 114.88.243.105
SELECT  *  FROM  sys_log WHERE ip_address_host='114.88.243.105' ORDER BY operate_time DESC
SELECT  *  FROM  sys_log ORDER BY operate_time ASC
SELECT  *  FROM  sys_log WHERE operate_time>='2023-09-24 08:20:58' 
ORDER BY operate_time ASC


SELECT *  FROM  common_memo  WHERE memo_sign='7'  ORDER BY memo_time DESC

SELECT *  FROM  common_memo  WHERE memo_sign='7' AND id<1120  ORDER BY memo_time DESC

UPDATE common_memo SET memo_sign='-7'
WHERE memo_sign='7' AND id<1120