Re^3: Re-indexing a SQL resultset by id


XP is just a number
	PerlMonks

Re^3: Re-indexing a SQL resultset by id

by Juerd (Abbot)

on Jul 09, 2011 at 23:42 UTC ( [id://913556]=note: print w/replies, xml )

Need Help??

in reply to Re^2: Re-indexing a SQL resultset by id
in thread Re-indexing a SQL resultset by id

SELECT * FROM student_classes;
Will you get several instances of each id? Yes?

Yes, but these fields are not called 'id'; here, it's just a suffix. A join, however, could result in multiple rows of the result set with the same id, even in a nice database design, so I do retract my observation about the database perhaps not being well-designed.

Juerd