Data-mysql obtains the number of consecutive values

! IMG (img.ask.csdn.netupload201507291438173228_28446.png). I want to obtain the maximum Dalian value of each field in the mysql data table. for example, the three consecutive values in the field num_1_x are all 0; I want to display num_1_x the number 0 in a row, that is to say, I want to get the number of consecutive occurrences of num_1_x 3. is there any such method in mysql? Mysql data

Let me talk about my needs;
I want to obtain the maximum number of Dalian values for each field in the mysql data table. for example, the three consecutive values in the field num_1_x are all 0. I want to display the number 0 consecutively for num_1_x, that is to say, I want to get the number of consecutive occurrences of num_1_x 3. is there any such method in mysql?