SQL: SELECT t.`app_ code`, SUM(t.`success_num`) AS success_ num, SUM(t.`

SQL: SELECT t.`app_code`,                SUM(t.`success_num`) AS success_num,                SUM(t.`failure_num`) AS failure_num,                SUM(t.`success_total_time`) AS success_toatl_time         FROM ds_api_call_total t          WHERE t.'app_code' = ?          GROUP BY t.`app_code
### Cause: java.sql.SQLSyntaxErrorException: 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 ''app_code' = 'yzt_slt' 
        GROUP BY t.`app_code' at line 6

The reason for this mistake is that I will directly sqlyog The query statement is directly copied to mybatis In file （ Why sqlyog Well , Because the Security Assistants inside the company are not allowed to use NaviCat, It's ridiculous ）

  So the error message displays ：t.`app_code`, SUM(t.`success_num`) AS success_num, SUM(t.`....

Also with Single quotation marks Of

resolvent ： Just delete the single quotation mark .

  So there's no problem . This error report is not very common , But also essential tips .

If this article helps you , One click and three links, please 【 Happy 】