@noelle Well, right now I have the unique primary key as a combination of account and item IDs but if I want to make the item IDs a foreign key then I can't use it as part of the primary key, so I need another value to link to each row associated with each account ID in order to form a unique row key
🤔 I guess doing a SELECT for the max value of that column where the account ID matches the desired ID when adding a new row would do the first part, but not the renumbering.
THE KICKER: I also ideally want it to renumber the rows on deletion of a row in the middle so you'll always have a sequential series of integers.
Today's "this is probably a terrible idea" MySQL question!
How do you add a secondary column for a two-column primary key so that it will create and fill in the second column in sequentially increasing integers, starting at 1, for all rows containing a specific ID in column one?
column one is a reference to an account ID, and each account can have multiple rows in the table. If there are ten rows with account ID 1, the second column should contain the numbers 1 through 10 for each row
today a writer in my fandom who I really admire told me that SHE HAS ONE OF MY FICS AS A BUTTON ON HER HOME SCREEN
assume everyone is trying their best.
My circus residency takes place in a dynamic space with many types of creativity going on simultaneously.
Today I was told they would be adding dog training in one of the rooms.
During the conversation about accommodating this new addition I was asked to reorganize my class so that the noisy portion took place either at a different time or in a different area.
It was only hours later that I realized the clowns were asked to quiet down in order to allow the dogs to concentrate.
@Wsteria I have not tried freezing it but this is my all-time favorite chicken soup recipe https://thepioneerwoman.com/cooking/chunky-chicken-soup/