别瞎猜! MySQL server version for the right syntax to use near '`tender_recover_wait`=`tender_recover_wait`+,`tender_capital_account`=`tender_ca' at line 1 就是 Mysql 认为有错的地方
update `wangdai_borrow_count` set user_id='337',`tender_success_times`=`tender_success_times`+1,`tender_success_account`=`tender_success_account`+2000.00,`tender_frost_account`=`tender_frost_account`+-2000,`tender_recover_account`=`tender_recover_account`+,`tender_recover_wait`=`tender_recover_wait`+,`tender_capital_account`=`tender_capital_account`+,`tender_capital_wait`=`tender_capital_wait`+,`tender_interest_account`=`tender_interest_account`+,`tender_interest_wait`=`tender_interest_wait`+,`tender_recover_times`=`tender_recover_times`+1,`tender_recover_times_wait`=`tender_recover_times_wait`+1 where user_id='337'
'`tender_recover_wait`=`tender_recover_wait`+,`tender_capital_account`=`tender_ca' 這樣寫能不錯嗎。。那個+後面應該有東西的。update `wangdai_borrow_count` set user_id='337',`tender_success_times`=`tender_success_times`+1,`tender_success_account`=`tender_success_account`+2000.00,`tender_frost_account`=`tender_frost_account`+-2000,`tender_recover_account`=`tender_recover_account`+?,`tender_recover_wait`=`tender_recover_wait`+?,`tender_capital_account`=`tender_capital_account`+?,`tender_capital_wait`=`tender_capital_wait`+?,`tender_interest_account`=`tender_interest_account`+?,`tender_interest_wait`=`tender_interest_wait`+?,`tender_recover_times`=`tender_recover_times`+1,`tender_recover_times_wait`=`tender_recover_times_wait`+1 where user_id='337'?的地方是需要有東西的,你都沒有,當然錯了。填上就好了。 另外你where user_id=337 ,那麼update時就沒有必要set user_id=337了。
MySQL server version for the right syntax to use near '`tender_recover_wait`=`tender_recover_wait`+,`tender_capital_account`=`tender_ca' at line 1
就是 Mysql 认为有错的地方
加什么呢?
這樣寫能不錯嗎。。那個+後面應該有東西的。update `wangdai_borrow_count` set user_id='337',`tender_success_times`=`tender_success_times`+1,`tender_success_account`=`tender_success_account`+2000.00,`tender_frost_account`=`tender_frost_account`+-2000,`tender_recover_account`=`tender_recover_account`+?,`tender_recover_wait`=`tender_recover_wait`+?,`tender_capital_account`=`tender_capital_account`+?,`tender_capital_wait`=`tender_capital_wait`+?,`tender_interest_account`=`tender_interest_account`+?,`tender_interest_wait`=`tender_interest_wait`+?,`tender_recover_times`=`tender_recover_times`+1,`tender_recover_times_wait`=`tender_recover_times_wait`+1 where user_id='337'?的地方是需要有東西的,你都沒有,當然錯了。填上就好了。
另外你where user_id=337 ,那麼update時就沒有必要set user_id=337了。