MySQL obtains discontinuous values. mysql obtains discontinuous values.

MySQL obtains discontinuous values. mysql obtains discontinuous values.
1. Problems

A table is displayed as shown in. In the data, running_number should be a continuity of 5 characters. Obtain the running_number that is disconnected from the connection. For example, 00001 and 00005 are missing 00004. We need to obtain the three running_number.

2. Solutions

2.1 obtain the critical point value before the number is missing.

Select running_number, time from (select running_number, time from device_data where device_id = 13 order by running_number asc) twhere not exists (select 1 from (select running_number from device_data where device_id = 13) B where B. running_number + 0 = t. running_number-1)

2.2 obtain the missing number based on the critical point