u011624157的专栏

常见代码疏漏 对于mysql 1.将 WHERE some_field = ‘${变量}’ 替换为 WHERE some_field = #{param} 2.将 like ‘%${变量}%’ 替换为 like concat(’%’, #{变量}, ‘%’) 3.将 like concat(’%’, ${变量}, ‘%’) 替换成 like concat(’%’, #{变量}, ‘%’) 将 WHERE some_field IN (${变量}) 替换为 WHERE `some_field` IN &l

SELECT t2.*, sum(t2.mergeFLag) OVER (PARTITION BY t2.pid ORDER BY t2.stime ROWS BETWEEN UNBOUNDED PRECEDING AND CURRENT ROW) AS flag FROM (SELECT *,...