为什么我手写的sql在sql工具上可以查出来,但是用mybatisPlus执行就一直报错?

最新推荐文章于 2024-05-23 19:17:58 发布

weixin_70985281

最新推荐文章于 2024-05-23 19:17:58 发布

阅读量449

点赞数 12

文章标签： sql java 数据库

本文链接：https://blog.csdn.net/weixin_70985281/article/details/138846830

版权

这是mybaisPlus的sql:,Page<Coupon> page = lambdaQuery()
        .eq(discountType!=null,Coupon::getDiscountType, discountType)
        .eq(status!=null,Coupon::getStatus, status)
        .eq(StringUtils.isNotBlank(name),Coupon::getName, name)
        .page(query.toMpPageDefaultSortByCreateTimeDesc());

这是sql语句:

select * from coupon ORDER BY create_time DESC LIMIT 10;

这是报的错误: 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 'specific, discount_value, threshold_amount, max_discount_amount, obtain_way, iss' at line 1
### The error may exist in com/tianji/promotion/mapper/CouponMapper.java (best guess)
### The error may involve defaultParameterMap
### The error occurred while setting parameters
### SQL: SELECT id, name, type, discount_type, specific, discount_value, threshold_amount, max_discount_amount, obtain_way, issue_begin_time, issue_end_time, term_days, term_begin_time, term_end_time, status, total_num, issue_num, used_num, user_limit, ext_param, create_time, update_time, creater, updater FROM coupon ORDER BY create_time DESC LIMIT ?
### 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 'specific, discount_value, threshold_amount, max_discount_amount, obtain_way, iss' at line 1
; bad SQL grammar []; nested exception is 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 'specific, discount_value, threshold_amount, max_discount_amount, obtain_way, iss' at line 1