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)ANDid NOT IN (SELECT id FROM (SELECT id FROM 表名 GROUP BY 字段1,字...原创 2020-01-14 16:49:26 · 1062 阅读 · 0 评论 -
Mybatis通过association 标签返回子类数据
键值对中设置 association查询具体对应ID实体类设置对应接受类传给前台直接给Product即可,具体内容product.XXX,这里值添加了一个product.brand的元素原创 2019-10-18 10:42:07 · 296 阅读 · 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 · 173 阅读 · 0 评论