Generating Random Data 🎲
INSERT INTO random_data (value) SELECT FLOOR(1 + (RAND() * 100)) FROM numbers_table LIMIT 10;
- RAND() generates random numbers.
- Multiply and floor values to get integers in a range.
INSERT INTO random_data (value) SELECT FLOOR(1 + (RAND() * 100)) FROM numbers_table LIMIT 10;