not right

[Anon]

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...

[Anon]

SQL is based on set theory so does it not have a have native concept of order. In other words, if you do a SELECT without an "ORDER BY" clause, then the database can return the records in any order it feels like. The order may even change between runs of the same SELECT.

To get around this, use an "ORDER BY" clause to order the result set. For example:

SELECT qty, descript, price
FROM mytable
WHERE qty > 0
ORDER BY price DESC, descript;

-- Michael
Darkstreak Computing & Innovations
www.darkstreak.com