probability Questions

Postgresql – Generating a unique alphanumeric code for client, reducing collisions

January 14, 2024
BVtp
2 Answers

I need to identify each booking with an easy code that can be given to the customer and used by them. This code is not the "real" booking identifier. That is, a booking already has a unique id which is…

VIEW QUESTION

MySQL: in designing a loot drop table, is it possible to specify a number of times the query repeats itself and outputs each result on the same table

October 20, 2022
montalope
2 Answers

as part of teaching myself SQL, I'm coding a loot drop table that I hope to use in D&D campaigns. the simplest form of the query is: SELECT rarity, CASE WHEN item=common THEN (SELECT item FROM common.table) WHEN item=uncommon THEN…

VIEW QUESTION