![](https://img-blog.csdnimg.cn/20201014180756926.png?x-oss-process=image/resize,m_fixed,h_64,w_64)
MYSQL
牛牛在路上
成为大牛的路上
展开
-
MySql 根据多个字段删除重复的数据
DELETE FROM 表名 WHERE (字段1,字段2,字段3) IN (SELECT 字段1,字段2,字段3 FROM (SELECT 字段1,字段2,字段3 FROM 表名 GROUP BY 字段1,字段2,字段3 HAVING COUNT()>1) s1) AND id NOT IN (SELECT id FROM (SELECT id FROM 表名 GROUP BY 字段1,字...原创 2020-01-14 16:49:26 · 1024 阅读 · 0 评论 -
Mybatis通过association 标签返回子类数据
键值对中设置 association 查询具体对应ID 实体类设置对应接受类 传给前台直接给Product即可,具体内容product.XXX,这里值添加了一个product.brand的元素原创 2019-10-18 10:42:07 · 273 阅读 · 0 评论 -
MySQL创建方法错误:This function has none of DETERMINISTIC, NO SQL
创建function时 出错信息: ERROR 1418 (HY000): This function has none of DETERMINISTIC, NO SQL, or READS SQL DATA in its declaration and binary logging is enabled (you might want to use the less safe log_bin_t...原创 2019-05-14 10:09:00 · 166 阅读 · 0 评论