resetting auto-incremented field to start at zero
This is a discussion on resetting auto-incremented field to start at zero within the MySQL forums, part of the Database Server Software category; --> >> Ideally, your PK shouldn't have any meaning outside identifying the row. > Alternatively, the primary key can be ...
| |||||||
| Register | FAQ | Members List | Calendar | Search | Today's Posts | Mark Forums Read |
02-28-2008, 10:32 AM
| ||||
| ||||
 Re: resetting auto-incremented field to start at zero >> Ideally, your PK shouldn't have any meaning outside identifying the row. > Alternatively, the primary key can be meaningful, that is > identify an object in real life, like a PartNumber, > SerialNumber or SocialSecurityNumber, in which case it > can't autoincrement, of course. No. >> Ideally, your PK shouldn't have any meaning outside identifying the row. Really, if you make your primary key meaningful in any other way than as a primary key, you open a big can of nasty worms. The worms do not come out immediately, but you can be sure they will. regards, -- Willem Bogaerts Application smith Kratz B.V. http://www.kratz.nl/      |
Linear Mode
