hi,
I have a table, with a column ID, which is auto_increment. Now I deleted the first ten; and now Im in trouble: when I add a new row the ID is still correct, but the place is not. When doing a SELECT * FROM table, I now get this:
ID ...
28
11
12
13
...
27
How can I let a newly added entry been put after the latest entry?
When writing this, I added two more lines and now its like this:
ID:
28
11
..
27
29
30
weird...
I have a table, with a column ID, which is auto_increment. Now I deleted the first ten; and now Im in trouble: when I add a new row the ID is still correct, but the place is not. When doing a SELECT * FROM table, I now get this:
ID ...
28
11
12
13
...
27
How can I let a newly added entry been put after the latest entry?
When writing this, I added two more lines and now its like this:
ID:
28
11
..
27
29
30
weird...