This week's giveaway is in the Android forum.
We're giving away four copies of Android Security Essentials Live Lessons and have Godfrey Nolan on-line!
See this thread for details.
The moose likes JDBC and the fly likes Record Deletion Big Moose Saloon
  Search | Java FAQ | Recent Topics | Flagged Topics | Hot Topics | Zero Replies
Register / Login

Win a copy of Android Security Essentials Live Lessons this week in the Android forum!
JavaRanch » Java Forums » Databases » JDBC
Bookmark "Record Deletion" Watch "Record Deletion" New topic

Record Deletion

ford Darcy Jr
Ranch Hand

Joined: Jan 26, 2005
Posts: 76

I am using mysql database. If a record in deleted say with recordid: 5, the next record that is the recordid:6, should move to the fifth position. How can I achieve this. Could anybody please help me on this.

Paul Clapham

Joined: Oct 14, 2005
Posts: 18541

I think you misunderstand relational databases. A database table is a collection of rows. The row number (which I guess is what you are talking about when you say "position" and "recordid") is not a feature of most databases and should not be relied on. Furthermore, an SQL Select statement is allowed to return rows in any order, unless an Order By clause is provided to control the order of rows. So basically row number is meaningless.

Or is "recordid" a column in your table, and you want to arrange things so the values in that column always form a sequence with no gaps? If so, why?
I agree. Here's the link:
subject: Record Deletion
Similar Threads
Locking and client identification
Getting next record
how to get Record ID in RMS
B&S Record Number Question