[nycphp-talk] every other record
rahmin at insite-out.com
Wed Feb 1 16:02:59 EST 2006
On 2/1/06 3:19 PM, "Chris Merlo" <chris at theyellowbox.com> wrote:
> If you have a table with an auto-generated ID, where you have ever deleted a
> record, in my experience with MySQL, the deleted ID won't get reused, and so
> your ID values will be 1, 2, 3, 5, 6, 7, etc... Therefore, that first line
> will grab records with IDs 1, 3, 6, 8, etc...
Is that not still every other record? (I don't particularly need every even
or odd record id, just every other entry.)
I don't particularly mind performing logic on the recordset after the fact,
but I would rather put the processing weight on the SQL side (more out of
principle than anything else).
More information about the talk