wood burning stoves 2.0*
The moose likes Object Relational Mapping and the fly likes About the table record in the database. Big Moose Saloon
  Search | Java FAQ | Recent Topics | Flagged Topics | Hot Topics | Zero Replies
Register / Login


Win a copy of EJB 3 in Action this week in the EJB and other Java EE Technologies forum!
JavaRanch » Java Forums » Databases » Object Relational Mapping
Bookmark "About the table record in the database." Watch "About the table record in the database." New topic
Author

About the table record in the database.

Ian Su
Greenhorn

Joined: Nov 18, 2010
Posts: 25
I would like to know something like this.I have a specific record to delete from a table.When the delete operation is successful,it will delete the row with specific id(Primary key & auto_increment').
Eg.I have a table with 3 rows and These 3 records have id field filled with int data(auto_increment).That is 1,2,3.What I would like to do is when I delete the 2nd row and the 3rd row id will automatically reassigned to the above row id(the deleted row id).The 3rd row id will be 2 and like that.How to do it?Is it possible to make it like that?I need some advice from you all.Thank you very much.
Bosun Bello
Ranch Hand

Joined: Nov 06, 2000
Posts: 1506
What you are trying to do is recycle key values, and it's generally not advisable to attempt it. You just have to ignore the deleted primary key values. Primary autoincrement keys in database are used to uniquely identify a given row and should be used for just that. Do not apply any business meaning to it.


Bosun (SCJP, SCWCD)
So much trouble in the world -- Bob Marley
Ian Su
Greenhorn

Joined: Nov 18, 2010
Posts: 25
Thank you very much Bosun Bello for your advice!But I just want to know whether there is any keywords for recycle key values in sql or if I want to do it,I just have to correct each record manually?
Bear Bibeault
Author and ninkuma
Marshal

Joined: Jan 10, 2002
Posts: 60046
    
  65

Apparently you are having some trouble understanding Bosun's reply. I'll spell it out a bit more clearly: DON'T DO THAT!

What problem are you trying to solve with this approach?


[Asking smart questions] [Bear's FrontMan] [About Bear] [Books by Bear]
Ian Su
Greenhorn

Joined: Nov 18, 2010
Posts: 25
No, Bear.I understand and accept.I just want to know whether any sql keyword for this one has or not.No real world reason to do this.It is just my thought of doing this thing.If I want to do 'the key recycle values',I just have to manually do in the database or from the code right?No easy and straight way?Sorry I am just a beginner.
Thank you Bear & Bosun!
Bear Bibeault
Author and ninkuma
Marshal

Joined: Jan 10, 2002
Posts: 60046
    
  65

No, there isn't.
 
I agree. Here's the link: http://aspose.com/file-tools
 
subject: About the table record in the database.
 
Similar Threads
How to take up the deleted record id number by the successor record id number?
providing edit, delete options to a table
how to read html table in servlet
Link IDs on Page
Hql delete syntax?