Kurs MySQL – data i czas cz 1 – 01

Iwona 
CREATE TABLE `events_datetime` (
  `idevents` INT NOT NULL AUTO_INCREMENT,
  `title` VARCHAR(45) NULL,
  `event_time` DATETIME NOT NULL,
  PRIMARY KEY (`idevents`))
ENGINE = InnoDB
DEFAULT CHARACTER SET = utf8;

INSERT INTO `events_datetime` (`title`, `event_time`) VALUES ('Koncert ', '2020-01-13 22:00:00');
INSERT INTO `events_datetime` (`title`, `event_time`) VALUES ('Trening', '2020-01-12 12:00:00');
INSERT INTO `events_datetime` (`title`, `event_time`) VALUES ('Wolontariat', '2020-01-13 12:00:00');
INSERT INTO `events_datetime` (`title`, `event_time`) VALUES ('Kino', '2020-01-12 16:30:00');
INSERT INTO `events_datetime` (`title`, `event_time`) VALUES ('Teatr', '2020-01-13 15:00:00');
INSERT INTO `events_datetime` (`title`, `event_time`) VALUES ('Basen', '2020-01-11 08:00:00');
INSERT INTO `events_datetime` (`title`, `event_time`) VALUES ('Mecz siatkówki w TV', '2020-01-13 00:00:00');
INSERT INTO `events_datetime` (`title`, `event_time`) VALUES ('Gala KSW', '2020-01-11 23:59:59');