Re: auto_increment insert-delete-insert

2005-02-24 Thread SGreen
"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 > rec

Re: auto_increment insert-delete-insert

2005-02-24 Thread Daniel Kasak
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 Kasa

auto_increment insert-delete-insert

2005-02-24 Thread Jim McAtee
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 a