From: Jan Steinman Date: February 9 2011 7:15pm Subject: Re: Auto-Increment Values in Mysql List-Archive: http://lists.mysql.com/mysql/224349 Message-Id: MIME-Version: 1.0 (Apple Message framework v1082) Content-Type: text/plain; charset=us-ascii Content-Transfer-Encoding: quoted-printable > From: Adarsh Sharma >=20 > I have an auto-increment column in Mysql database table. Let's say the = column has below values : I'll echo what others have said. Auto-increment is typically used to generate unique primary keys. If = this column is your primary key, DO NOT change its value! PK =3D = identity. "The value of a record is the key, the whole key, and nothing but the = key, so help me Codd." :-) If the auto-inc field is NOT the primary key, AND if it must have = contiguous values, as others said, you probably want to have your = business logic keeping track of it, rather than using auto-increment. I know others have said the same thing, but sometimes it help to hear it = put differently. ---------------- In my mind are many dwellings. Each of the dwellings we create ourselves = - the house of anger, the house of despair, the house of self pity, the = house of indifference, the house of negative, the house of positive, the = house of hope, the house of joy, the house of peace, the house of = enthusiasm, the house of cooperation, the house of giving. Each of these = houses we visit each day. We can stay in any house for as long as we = want. We can leave these mental houses any time we wish. We create the = dwelling, we stay in the dwelling, we leave the dwelling whenever we = wish. We can create new rooms, new houses. Whenever we enter these = dwellings, this becomes our world until we leave for another. What world = will we live in today? -- Don Coyhis :::: Jan Steinman, EcoReality Co-op ::::