Beginning MySQL Tutorial
One of the fastest SQL (Structured Query Language) database servers currently on the market is the MySQL server, developed by T.c.X. DataKonsultAB. MySQL, available for download at http://www.mysql.com, offers the data base programmer with an array of options and capabilities rarely seen in other database servers. What's more, MySQL is free of charge for those wishing to use it for private and commercial use.
| Name: |
Pweb |
| Subject: |
DELETE / Index/ JSP |
| Date: |
08-02-1999 11:26AM |
Hi...
I'm using Java Server Pages to access and control a database...
Everything works well, except when I delete a record in the middle of the table. The records are indexed with auto_increment, but when I delete, say, record 5, it deletes it but it doesn't re-number the rest of the record. This becomes a real problem since I'm counting on the records to be sequentially numbered.
Should I:
a) write a script that re-numbers all of the records above the one I deleted?
b) find another, easier, solution?
Thanks for the help
|
Other posts in this thread:
| Top | | • DELETE / Index/ JSP | Pweb | 08-02-1999 11:26AM |
Reply to this post:
|
 |
Visit the MySQL Forum!
New On DevShed:
Hot Forum Topics:
|
