
19.07.2020, 20:28
|
|
Active Member
Регистрация: 17.10.2018
Сообщений: 262
С нами:
3986966
Репутация:
1
|
|
Сообщение от TOX1C
Второй предложенный подошел.
Тогда так:
Код:
MariaDB [Tenda]> select * from tmp_TendaPins where PIN like '4187%' order by n;
+------+---------+------+------+------+------+------+------+------+------+------+------+
| n | PIN | X | m | m1 | m2 | m3 | m4 | m5 | m6 | m7 | m8 |
+------+---------+------+------+------+------+------+------+------+------+------+------+
| 2 | 4187495 | 1 | 6 | 1 | 5 | 0 | 0 | 0 | 0 | 0 | 0 |
| 127 | 4187751 | 0 | 3 | 0 | 3 | 0 | 0 | 0 | 0 | 0 | 0 |
| 426 | 4187239 | 0 | 1 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 |
| 443 | 4187494 | 0 | 1 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 |
+------+---------+------+------+------+------+------+------+------+------+------+------+
4 rows in set (0.00 sec)
|
|
|