Jump to content


Photo

controlled incrementing


  • Please log in to reply
1 reply to this topic

#1 cerin

cerin
  • Members
  • PipPip
  • Member
  • 16 posts

Posted 21 February 2006 - 12:10 AM

I would like to know what you put into mysql to increment numbers, BUT only the ones that have a certain value like every entry with the value "2023" will have a number in seperate column that increments only for entries with this value. On another note, can mysql do the primary sorting and a secondary sort? For example: Sorting by values assigned to rows, and then sorting every row that has the same value by a seperate value.
If you don't understand what I'm asking I'd be glad to explain more thoroughly.

#2 fenway

fenway
  • Staff Alumni
  • MySQL Si-Fu / PHP Resident Alien
  • 16,199 posts
  • LocationToronto, ON

Posted 21 February 2006 - 12:28 AM

This is possible -- you simply have to make the AUTO_INCREMENT column part of a multiple-column index which includes both the column with the ID and the column with the "2023" in it. And yes, you can multiple fields in an ORDER BY clause.
Seriously... if people don't start reading this before posting, I'm going to consider not answering at all.




0 user(s) are reading this topic

0 members, 0 guests, 0 anonymous users