[XFlawless]

Quote:

Originally Posted by iTorran For each new row inserted into MySQL table, "ID" goes up by 1. So e.g. if i add 5 rows. ID: 1 ID: 2 ID: 3 ID: 4 ID: 5 But when i remove one.. e.g. ID: 5 and add a new row, the ID of the new row is ID: 6 So it goes: ID: 1 ID: 2 ID: 3 ID: 4 ID: 6 Is there anyway to make it goto 5? (if you know waht i mean)

No you can't do that afaik. However if you have a PRIMARY KEY then you can fix the key ID by using ANALYSE TABLE table_name;