MySQL

MySQL: Tabela contendo intervalo de horas de 15 em 15 min

CREATE TABLE IF NOT EXISTS `horarios` (
  `id` INT AUTO_INCREMENT,
  `horario` VARCHAR(5) NOT NULL,
  PRIMARY KEY (`id`) )
ENGINE = InnoDB;
INSERT INTO `horarios` (`id`, `horario`) VALUES (NULL, '07:00');
INSERT INTO `horarios` (`id`, `horario`) VALUES (NULL, '07:15');
INSERT INTO `horarios` (`id`, `horario`) VALUES (NULL, '07:30');
INSERT INTO `horarios` (`id`, `horario`) VALUES (NULL, '07:45');
INSERT INTO `horarios` (`id`, `horario`) VALUES (NULL, '08:00');
INSERT INTO `horarios` (`id`, `horario`) VALUES (NULL, '08:15');
INSERT INTO `horarios` (`id`, `horario`) VALUES (NULL, '08:30');
INSERT INTO `horarios` (`id`, `horario`) VALUES (NULL, '08:45');
INSERT INTO `horarios` (`id`, `horario`) VALUES (NULL, '09:00');
INSERT INTO `horarios` (`id`, `horario`) VALUES (NULL, '09:15');
INSERT INTO `horarios` (`id`, `horario`) VALUES (NULL, '09:30');
INSERT INTO `horarios` (`id`, `horario`) VALUES (NULL, '09:45');
INSERT INTO `horarios` (`id`, `horario`) VALUES (NULL, '10:00');
INSERT INTO `horarios` (`id`, `horario`) VALUES (NULL, '10:15');
INSERT INTO `horarios` (`id`, `horario`) VALUES (NULL, '10:30');
INSERT INTO `horarios` (`id`, `horario`) VALUES (NULL, '10:45');
INSERT INTO `horarios` (`id`, `horario`) VALUES (NULL, '11:00');
INSERT INTO `horarios` (`id`, `horario`) VALUES (NULL, '11:15');
INSERT INTO `horarios` (`id`, `horario`) VALUES (NULL, '11:30');
INSERT INTO `horarios` (`id`, `horario`) VALUES (NULL, '11:45');
INSERT INTO `horarios` (`id`, `horario`) VALUES (NULL, '12:00');
INSERT INTO `horarios` (`id`, `horario`) VALUES (NULL, '12:15');
INSERT INTO `horarios` (`id`, `horario`) VALUES (NULL, '12:30');
INSERT INTO `horarios` (`id`, `horario`) VALUES (NULL, '12:45');
INSERT INTO `horarios` (`id`, `horario`) VALUES (NULL, '13:00');
INSERT INTO `horarios` (`id`, `horario`) VALUES (NULL, '13:15');
INSERT INTO `horarios` (`id`, `horario`) VALUES (NULL, '13:30');
INSERT INTO `horarios` (`id`, `horario`) VALUES (NULL, '13:45');
INSERT INTO `horarios` (`id`, `horario`) VALUES (NULL, '14:00');
INSERT INTO `horarios` (`id`, `horario`) VALUES (NULL, '14:15');
INSERT INTO `horarios` (`id`, `horario`) VALUES (NULL, '14:30');
INSERT INTO `horarios` (`id`, `horario`) VALUES (NULL, '14:45');
INSERT INTO `horarios` (`id`, `horario`) VALUES (NULL, '15:00');
INSERT INTO `horarios` (`id`, `horario`) VALUES (NULL, '15:15');
INSERT INTO `horarios` (`id`, `horario`) VALUES (NULL, '15:30');
INSERT INTO `horarios` (`id`, `horario`) VALUES (NULL, '15:45');
INSERT INTO `horarios` (`id`, `horario`) VALUES (NULL, '16:00');
INSERT INTO `horarios` (`id`, `horario`) VALUES (NULL, '16:15');
INSERT INTO `horarios` (`id`, `horario`) VALUES (NULL, '16:30');
INSERT INTO `horarios` (`id`, `horario`) VALUES (NULL, '16:45');
INSERT INTO `horarios` (`id`, `horario`) VALUES (NULL, '17:00');
INSERT INTO `horarios` (`id`, `horario`) VALUES (NULL, '17:15');
INSERT INTO `horarios` (`id`, `horario`) VALUES (NULL, '17:30');
INSERT INTO `horarios` (`id`, `horario`) VALUES (NULL, '17:45');
INSERT INTO `horarios` (`id`, `horario`) VALUES (NULL, '18:00');
INSERT INTO `horarios` (`id`, `horario`) VALUES (NULL, '18:15');
INSERT INTO `horarios` (`id`, `horario`) VALUES (NULL, '18:30');
INSERT INTO `horarios` (`id`, `horario`) VALUES (NULL, '18:45');
INSERT INTO `horarios` (`id`, `horario`) VALUES (NULL, '19:00');
INSERT INTO `horarios` (`id`, `horario`) VALUES (NULL, '19:15');
INSERT INTO `horarios` (`id`, `horario`) VALUES (NULL, '19:30');
INSERT INTO `horarios` (`id`, `horario`) VALUES (NULL, '19:45');
INSERT INTO `horarios` (`id`, `horario`) VALUES (NULL, '20:00');
INSERT INTO `horarios` (`id`, `horario`) VALUES (NULL, '20:15');
INSERT INTO `horarios` (`id`, `horario`) VALUES (NULL, '20:30');
INSERT INTO `horarios` (`id`, `horario`) VALUES (NULL, '20:45');
INSERT INTO `horarios` (`id`, `horario`) VALUES (NULL, '21:00');
INSERT INTO `horarios` (`id`, `horario`) VALUES (NULL, '21:15');
INSERT INTO `horarios` (`id`, `horario`) VALUES (NULL, '21:30');
INSERT INTO `horarios` (`id`, `horario`) VALUES (NULL, '21:45');
INSERT INTO `horarios` (`id`, `horario`) VALUES (NULL, '22:00');
INSERT INTO `horarios` (`id`, `horario`) VALUES (NULL, '22:15');
INSERT INTO `horarios` (`id`, `horario`) VALUES (NULL, '22:30');
INSERT INTO `horarios` (`id`, `horario`) VALUES (NULL, '22:45');
INSERT INTO `horarios` (`id`, `horario`) VALUES (NULL, '23:00');
INSERT INTO `horarios` (`id`, `horario`) VALUES (NULL, '23:15');
INSERT INTO `horarios` (`id`, `horario`) VALUES (NULL, '23:30');
INSERT INTO `horarios` (`id`, `horario`) VALUES (NULL, '23:45');

Deixe um comentário

O seu endereço de e-mail não será publicado. Campos obrigatórios são marcados com *