Gistrec

Получить не занятый ID в диапазоне

Jun 15th, 2019
185
0
Never
1
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
MySQL 0.21 KB | None | 0 0
  1. SELECT id + 1 AS available_id
  2. FROM likepanel.account_group AS t
  3. WHERE
  4.     id >= 100
  5.     AND id < 200
  6.     AND NOT EXISTS (
  7.         SELECT *
  8.         FROM likepanel.account_group
  9.         WHERE id = t.id + 1
  10.     )
  11. ORDER BY id
  12. LIMIT 1
Comments
  • User was banned
Add Comment
Please, Sign In to add comment