UPDATE pre_connect_memberbindlog SET dateline = CONCAT(dateline,"000")
在字段后添加字符串
SELECT * FROM proxy_spread_user_bonus px WHERE px.baseid IN(145,154) ORDER BY px.time DESC
要实现这句sql的功能
实体类:
@TableField(exist=false)
private List<Long> baseidlist = new ArrayList<>(); 并且声明get() set()方法
Controller 类赋值:
XML 文件sql: