sql
weixin_45508572
添砖加瓦
展开
-
【无标题】自定义sql 函数根据某个特殊符号切割成数组取数据
自定义函数转载 2022-09-21 15:23:32 · 219 阅读 · 0 评论 -
mysql查询近几日之内的数据
这里查询的是近一周的数据例子: SELECT * FROM cnpc_employee WHERE cnpc_employee.status = 0 AND cnpc_employee.hose != '12356' and cnpc_employee.on_job = #{onJob}and DATE_SUB(CURDATE(), INTERVAL 7 DAY) <![CDATA[ <= ]]> date(departure_time)注意:7原创 2020-08-05 10:34:19 · 158 阅读 · 0 评论 -
find_in_set/like/in区别
mysql中这三个的区别1.FIND_IN_SET2.like3.infind_in_set()和in的区别:CREATE TABLE `tb_test` ( `id` int(8) NOT NULL auto_increment, `name` varchar(255) NOT NULL, `list` varchar(255) NOT NULL, PRIMARY KEY (`id`));INSERT INTO `tb_test` VALUES (1, 'name', 'd转载 2020-08-04 17:31:34 · 142 阅读 · 0 评论 -
mysql单表统计不同类型计数实例
mysql单表统计不同类型计数实例SELECTcount(*) as total,ifnull(sum(case when sex = ‘男’ then 1 else 0 end),0) as man,ifnull(sum(case when sex = ‘女’ then 1 else 0 end),0) as woman,ifnull(sum(case when political_status = ‘党员’ then 1 else 0 end),0) as communist,ifnull原创 2020-08-04 14:23:46 · 481 阅读 · 0 评论