![](https://img-blog.csdnimg.cn/20201014180756927.png?x-oss-process=image/resize,m_fixed,h_64,w_64)
MySQL
此为咸鱼
这个作者很懒,什么都没留下…
展开
-
MySql去重重复数据
select * from cpic a where not exists (select 1 form cpic b where b.barcode=a.barcode and b.creatTime > a.creatTime)原创 2020-08-25 16:31:33 · 257 阅读 · 0 评论 -
MySQL将查询结果有小数位就保留,如果小数位是0,转为整数
select 0+CAST(result.count as char) from (select round(10.000001, 2) as count) as result原创 2020-05-31 17:02:51 · 3228 阅读 · 1 评论 -
MySQL将查询出的结果insert至新表
insert into hrs.`feedback_aggregate_statistics` select `medicine_name`,count(1),now(),now() from `feedback_form` where `classifier` = 'product_feedback' group by `medicine_name`;原创 2019-12-09 14:01:31 · 1981 阅读 · 0 评论