1,<![CDATE[ sql]> 用cdate将sql包起来
SELECT * FROM USER u WHERE TO_DAYS(NOW())-TO_DAYS(u.creatTime)<7
<![CDATE[ SELECT * FROM USER u WHERE TO_DAYS(NOW())-TO_DAYS(u.creatTime)<7]>
2使用转义字符串,
SELECT * FROM USER u WHERE TO_DAYS(NOW())-TO_DAYS(u.creatTime)<7
SELECT * FROM USER u WHERE TO_DAYS(NOW())-TO_DAYS(u.creatTime)<7
原符号 < <= > >= & ' "
替换符号< <= > >= & ' "