Select Empty Row.sql

SELECT f.id + 1 AS empty
FROM <table> f
  LEFT OUTER JOIN <table> r ON f.id + 1 = r.id
WHERE r.id IS NULL
ORDER BY f.id
LIMIT 1;


SELECT f.id + 1 AS empty
FROM <table> f
WHERE (
        SELECT 1
        FROM <table> s
        WHERE s.id = f.id + 1
      ) IS NULL
ORDER BY f.id
LIMIT 1;