这是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