Jump to content

Recommended Posts

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.
Link to comment
https://forums.phpfreaks.com/topic/3497-controlled-incrementing/
Share on other sites

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.
Link to comment
https://forums.phpfreaks.com/topic/3497-controlled-incrementing/#findComment-12044
Share on other sites

This thread is more than a year old. Please don't revive it unless you have something important to add.

Join the conversation

You can post now and register later. If you have an account, sign in now to post with your account.

Guest
Reply to this topic...

×   Pasted as rich text.   Restore formatting

  Only 75 emoji are allowed.

×   Your link has been automatically embedded.   Display as a link instead

×   Your previous content has been restored.   Clear editor

×   You cannot paste images directly. Upload or insert images from URL.

×
×
  • Create New...

Important Information

We have placed cookies on your device to help make this website better. You can adjust your cookie settings, otherwise we'll assume you're okay to continue.