> I have another question about record deletion from
> database.
>
> For example, my database has 10 records with ids 1
> through 10. If I delete id #10 then everything is good
> and all the records are still 1 through 9. However, if
> I delete record id #4, then in my db I would have
> records 1 through 10 with id #4 missing.
>
> Is there a command that syncs the database? How do I
> go about this to keep all the ids in the right order
> after the deletion? or What do I need to do to prevent
> that from happenning?
>
> All the help is appreciated.
>
> Anna Vester
> http://www.veanndesign.com
> http://reviews.veanndesign.com
You should not alter your primary key value since other tables may use this as a relationship. If
you want to have values which remain contiguous, use a different field for the value you intend to
display or use a counter variable in the program.
James
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.
