u011624157的专栏

常见代码疏漏对于mysql1.将 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 *,...