I’m working on creating a more efficient way to UPDATE random rows in a ticket allocation website we have. Currently, we pre populate the tickets table with ticket numbers in subsequent order, i.e 1,2,4 etc. Each ticket number being a row. When a customer then places their order we use the following SQL query to […]
Categories
UPDATE random rows
- Post author By Jessica Alba
- Post date March 4, 2021
- No Comments on UPDATE random rows
- Tags 2, 4 etc. Each ticket number being a row. When a customer then places their order we use the following SQL query to reserve their random ticket, how much more efficient is this method compared to the RAND() function or is there any better ways of doing what I'm trying to achieve?, i.e. 1, I'm working on creating a more efficient way to UPDATE random rows in a ticket allocation website we have. Currently, we pre populate the tickets table with ticket numbers in subsequent order