简体中文(ZH-CN) English(EN) 繁体中文(ZH-TW) 日本語(JA) 한국어(KO) Melayu(MS) Français(FR) Deutsch(DE)
Home > Database > Mysql Tutorial > body text

数据-mysql 获取连续值的个数

WBOY
Release： 2016-06-06 09:39:37
Original
1393 people have browsed it

mysql数据

图片说明
我说一下我的需求；
我想获取mysql数据表各个字段的最大连值的个数，例如现在字段num_1_x 里面的三个连续的值都是0；我要把num_1_x 连续出现数字0的次数，就是说我要得到现在num_1_x的连续出现次数3，请问一下mysql里面有没有这种方法？

Related labels：
mysql 数据
source：php.cn
Previous article：mysql-有关 高重复率 数据的 数据库设计 求指导 Next article：mysql-MySQL中的group_concat函数怎么用sybase实现？
Statement of this Website
The content of this article is voluntarily contributed by netizens, and the copyright belongs to the original author. This site does not assume corresponding legal responsibility. If you find any content suspected of plagiarism or infringement, please contact admin@php.cn
Latest Articles by Author
Latest Issues
Write sql statements using tp5 framework How to write the following sql statement using tp? select * from `student` where sex = 1 a...
From 2021-09-03 10:30:52
0
3
848
spring - Regarding the problems encountered in keyword query: the problem of writing sql statements into java I am a database novice. My senior assigned me a keyword query task. I encountered some pro...
From 2017-05-27 17:41:38
0
2
585
PHP compound query statement? SELECT COUNT(*) AS num FROM lzh_cds c LEFT JOIN lzh_rds r ON c.rd_id=r.rd_id LEFT JOIN lzh...
From 2017-05-16 13:14:40
0
1
512
node.js - nodejs的根数据库连接的后端开源框架市面上有吗？ 想做一个dao层把curd各语句和各种查询条件抽出来要包含() or and like in notin 跨表查询 orderly group 甚至union不知道市面上有没有这种...
From 2017-04-17 16:02:18
0
1
298
mysql查询id,IN根据结果模糊问题 select id,title,content from myarticle where id IN(219,220,222,225) and content like '明明' ...
From 2017-04-17 13:47:58
0
2
476
Related Topics
More>
Popular Recommendations
Popular Tutorials
More>
Related Tutorials
Popular Recommendations
Latest courses
Latest Downloads
More>
Web Effects
Website Source Code
Website Materials
Front End Template
About us Disclaimer Sitemap
php.cn：Public welfare online PHP training，Help PHP learners grow quickly！