RE: Table inserts with JDBC - Terry Westley - com.mysql.lists.java

4 messages in com.mysql.lists.javaRE: Table inserts with JDBC

From	Sent On	Attachments
Alf Burke	13 Jun 2001 10:14
mmat...@thematthews.org	13 Jun 2001 12:01
Paul DuBois	13 Jun 2001 15:37
Terry Westley	14 Jun 2001 06:02

Subject:	RE: Table inserts with JDBC
From:	Terry Westley (twes...@acm.org)
Date:	06/14/2001 06:02:07 AM
List:	com.mysql.lists.java

Alf Burke wrote:

Does anyone know how to set a cursor at (say) row 10 of a 100 row table and then have all subsequent inserts insert at the cursor position?

Whenever anyone asks me a question like this, I ask them, "Why do you want to do this?"

If you care what "physical" order your rows are stored in (as this question seems to imply), then you probably don't have the right design yet. Your design should not depend on physical order because relational databases (typically) make no guarantee on storage or retrieval order. It's up to you to design the tables and the relationships between them and your select statements to get what you need.