学习记录442@MySQL desc关键字引发的错误

完整错误

You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'desc=''  where `_id`='c2ffc4d7159f493da3114f'' at line 1

原sql语句

String sql1="update repaymentcomputefaxi set reBenjin=?,reMoneyTime=?,getReMoneyTime=?,days=?,rateOfDay=?,reFaXi=?,desc=?  where _id=?";   
参数就不多说了....

原因

desc是mysql关键字，不要这样赤裸裸得作为列来操作；
最稳健得方式是将列全部用撇号包裹。如下：

String sql1="update `repaymentcomputefaxi` set `reBenjin`=?,`reMoneyTime`=?,`getReMoneyTime`=?,`days`=?,`rateOfDay`=?,`reFaXi`=?,`desc`=?  where `_id`=?";