That's the way auto_increment works. You'll have to make the field
an int (no auto_increment) and supply a record id yourself on insert.
On Mon, 01 Jul 2002 08:21:18 +1200, Chris Payne wrote:
Hi there everyone,
I have my id field auto incrementing (Of course) and I have a utility
that
You should not rely on the autonumber as a sorting method. You should use it
as a reference. I see you have two easy options (there may be more, but this
seems suitable).
1. Get the SQL to pull a random record (requires mySQL 3.23.x or higher)
SELECT * FROM tblName ORDER BY RAND()