Caused by: java.sql.SQLSyntaxErrorException: You have an error in your SQL syntax； check the manual

前言

编写xml文件报错

---

错误代码如下：

### Error querying database.  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 'count(gift_id) giftCategoryNums,
        create_time createTime
     
    WHERE ' at line 1
### The error may exist in filxml]
### The error may involve defaultParameterMap
### The error occurred while setting parameters
### SQL: select count(0) from (send_uid sendUid,accept_uid acceptUid,gift_id giftId, type,gift_num giftNum,count(gift_id) giftCategoryNums,         create_time createTime           WHERE 1=1                         and send_uid =8888888                              GROUP BY gift_id, accept_uid         ORDER BY gift_price DESC) tmp_count
### Cause: java.sql.SQLSyntaxErrorException: You have an error in your SQL syntax; check the manual that correspo