| List: | General Discussion | « Previous MessageNext Message » | |
| From: | Jason Pruim | Date: | August 29 2007 4:38pm |
| Subject: | Reset a auto increment field? | ||
| View as plain text | |||
Is there away to reset an auto incrementing field count? I have a database that currently has 935 records in it but because I have deleted a few the current number used for NEW records is 938 :) How can I get it to count the records and assign a record number based on the total count? Hope that makes sense! Thanks for looking! :) -- Jason Pruim Raoset Inc. Technology Manager MQC Specialist 3251 132nd ave Holland, MI, 49424 www.raoset.com japruim@stripped
| Thread | ||
|---|---|---|
| • Reset a auto increment field? | Jason Pruim | 29 Aug |
| • Re: Reset a auto increment field? | Shawn Green | 29 Aug |
| • Re: Reset a auto increment field? | Jason Pruim | 29 Aug |
| • Re: Reset a auto increment field? | Shawn Green | 29 Aug |
| • RE: Reset a auto increment field? | Jerry Schwartz | 29 Aug |
| • Re: Reset a auto increment field? | dpgirago | 29 Aug |
| • RE: Reset a auto increment field? | emierzwa | 29 Aug |
| • Re: Reset a auto increment field? | Jason Pruim | 29 Aug |
| • RE: Reset a auto increment field? | emierzwa | 29 Aug |
| • RE: Reset a auto increment field? | Jerry Schwartz | 29 Aug |
