Find mininum unused value in mysql table
- by splattru
I have a MySQL table like this:
+--------+-------+
+ Server + Port +
+--------+-------+
+ 1 + 27001 +
+--------+-------+
+ 2 + 27002 +
+--------+-------+
+ 4 + 27004 +
+--------+-------+
How you can see - here was 27003 port - but it was deleted some time ago (just for example).
Is there some way to know the minimum value that…