• Post Reply
  • Bookmark Topic Watch Topic
  • New Topic

Record Deletion

 
ford Darcy Jr
Ranch Hand
Posts: 76
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
Hi,

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.

Thanks.
 
Paul Clapham
Sheriff
Posts: 20980
31
Eclipse IDE Firefox Browser MySQL Database
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
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?
 
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic