![](https://img-blog.csdnimg.cn/20201014180756918.png?x-oss-process=image/resize,m_fixed,h_64,w_64)
sql
丘下两点vvv
诚心学习
展开
-
JAVA进阶之路-mysq 删除重复数据
首先创建一张存有去除重复数据的零时表(通过group by 去重,后面的字段就按每个人的表的需求不同去写就行了) create table tmp (select code,period,open,close,high,low,volume,beginTime,endTime from kline_btc_usdt group by code,period,open,close,high,low,volume,beginTime,endTime); 然后删除原始表的数据 TRUNCATE table kli原创 2021-04-20 17:32:34 · 183 阅读 · 0 评论 -
JAVA进阶之路-mysq 查询某个字段中重复数据
这里写自定义目录标题JAVA进阶之路-mysq 查询某个字段中重复数据 JAVA进阶之路-mysq 查询某个字段中重复数据 select a.beginTime FROM (select * from kline_dash_usdt a where period=“4hour” ORDER BY beginTime) a group by a.beginTime having count(a.beginTime) > 1 select * from kline_dash_usdt a wher原创 2021-03-12 09:39:24 · 172 阅读 · 0 评论