Hello group, I have a table that I create with
CREATE TABLE SuperTest ( ID int(11) NOT NULL AUTO_INCREMENT, Name varchar(64) NOT NULL, Domain varchar(64) NOT NULL, PRIMARY KEY(ID) ); I use that same thing to create a the same table on two servers. On one server (mysql Ver 11.16 Distrib 3.23.49, for portbld-freebsd4.6 (i386)) If I add, say five records I get ID to be 1,2,3,4,5. Then I delete ID 5 and insert a new record and it's id is 6. So now I have 1,2,3,4,6. That's what I want it to do. However on the other server (mysql version ???) if I have 1,2,3,4,5, delete ID 5 and insert a new one it makes the new one ID 5. I suppose because it's the next number. I'm not really even sure what to call it besides 'non reusable auto_increment'. I can't seem to find anything on mysql.com about what settings, version, etc cause it to work either way. Any insight would be greatly appreciated as in some situations I really need it to be one way or the other consistently across servers. TIA DMuey -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]