Requesting a period of time during the day?

Question

MySQL

I apologize for the lamer question, I need a simple query to the database (MySql) with the output of the number of 15 minute intervals in the period from 09.00 to 18.00 hours, and recording them all in separate rows of the table with the minut_15 (Timestamp) field.

Answer 1

SELECT CONCAT(`h`.`hour`, ':', `m`.`minute`, ':00')
FROM (
  SELECT '09' AS `hour`
  UNION SELECT '10'
  UNION SELECT '11'
  UNION SELECT '12'
  UNION SELECT '13'
  UNION SELECT '14'
  UNION SELECT '15'
  UNION SELECT '16'
  UNION SELECT '17'
) AS `h`
JOIN (
  SELECT '00' AS `minute`
  UNION SELECT '15'
  UNION SELECT '30'
  UNION SELECT '45'
) AS `m`