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.