Mike Franks <[EMAIL PROTECTED]> writes
>There should be
>no reason for you to worry about any "gaps",
agreed...
> and you should never base
>any query or sorting logic on the key - it should only be used to fetch
>a particular record.
I think that this sounds a little confusing, and I don't think that I
agree with you here. If the records refer to students in a class, you
can use the student number for various things, (but you wouldn't
renumber all the students if one left!). But you could use the key ID
to find the student, or to attach the student to courses, or check the
students account, etc.
I used to work on a database which was a little unsteady on it's feet in
the 90s, and we were warned never to rely on the key being the same -
the database might throw a wobbler, and change all the values in this
key. As far as I know, this no longer applies to any modern database,
so you can use the key for whatever you want.
>Think of a row of houses on a particular city street. If one house is
>demolished for any reason, there is no need to renumber any of the
>surrounding houses.
Good example! It would make the house numbers "neat", but would cause a
lot of problems with no advantage gained at the end of it.
--
Pete Clark
Free advertising for your website, business, or organisation at:
http://www.hotcosta.com/resources.php
Community email addresses:
Post message: [email protected]
Subscribe: [EMAIL PROTECTED]
Unsubscribe: [EMAIL PROTECTED]
List owner: [EMAIL PROTECTED]
Shortcut URL to this page:
http://groups.yahoo.com/group/php-list
SPONSORED LINKS
| Php mysql | Job postings |
YAHOO! GROUPS LINKS
- Visit your group "php-list" on the web.
- To unsubscribe from this group, send an email to:
[EMAIL PROTECTED]
- Your use of Yahoo! Groups is subject to the Yahoo! Terms of Service.
