Finding missing row in a table - MySQL
#1

Let's say I have a table with fields:

Код:
Number     Value     Value
1          5         5
2          5         5
3          5         5
4          5         5

6          5         5
7          5         5
8          5         5
9          5         5
--
How would I go about finding the missing row. Which would be 5. Then create the row and arrange it, so it keeps going in order: 4, 5, 6..
Reply


Messages In This Thread
Finding missing row in a table - MySQL - by -Prodigy- - 14.01.2012, 23:50
Re: Finding missing row in a table - MySQL - by Vince - 14.01.2012, 23:54
Re: Finding missing row in a table - MySQL - by Jefff - 15.01.2012, 00:01

Forum Jump:


Users browsing this thread: 2 Guest(s)