mysql
oracle
order by id desc limit #{offset},#{pageSize}
where rownum <= #{offset}+#{pageSize} )
where rn >#{offset})
order by id DESC
#{startDate}
t.createtime
to_date('#{startDate}','yyyy-mm-dd HH24:MI:SS')
to_char(t.createtime,'yyyy-MM-dd') as createtime
now()
sysdate
type在MySQL中不是關鍵字
type 在oracle裡是關鍵字 需要在SQL語句中將關鍵字全部大寫並且加上雙引號