auto_increment insert-delete-insert

Say a row is inserted into a table with an auto_increment column and then deleted before another record is inserted. When a new row is inserted, will the value of the auto_increment column be the same as the deleted record's, or will it be one greater? -- MySQL General Mailing List For list

Re: auto_increment insert-delete-insert

Jim McAtee wrote: Say a row is inserted into a table with an auto_increment column and then deleted before another record is inserted. When a new row is inserted, will the value of the auto_increment column be the same as the deleted record's, or will it be one greater? Greater. -- Daniel

Re: auto_increment insert-delete-insert

Jim McAtee [EMAIL PROTECTED] wrote on 02/24/2005 04:50:11 PM: Say a row is inserted into a table with an auto_increment column and then deleted before another record is inserted. When a new row is inserted, will the value of the auto_increment column be the same as the deleted record's,