当前位置：网站首页>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.`

2022-07-20 20:20:00 【YOUNG.K】

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

这个错误的原因是因为我直接将sqlyog 查询的语句直接复制到了mybatis文件中（为啥用sqlyog呢，是因为公司内部的安全助手不让用NaviCat，就离谱）