MySQL 8.0

By using db<>fiddle, you agree to license everything you submit by Creative Commons CC0.
CREATE TABLE movies (
     title VARCHAR(50) NOT NULL,
     duration INT UNSIGNED NOT NULL,
     id INT UNSIGNED NOT NULL,
     PRIMARY KEY(id)
);
SHOW CREATE TABLE movies;


Table
Create Table


movies
CREATE TABLE `movies` (
  `title` varchar(50) NOT NULL,
  `duration` int unsigned NOT NULL,
  `id` int unsigned NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci


CREATE TABLE genres (
     genre VARCHAR(50) NOT NULL,
     id INT UNSIGNED NOT NULL,
     PRIMARY KEY(id)
);
SHOW CREATE TABLE genres;


Table
Create Table


genres
CREATE TABLE `genres` (
  `genre` varchar(50) NOT NULL,
  `id` int unsigned NOT NULL,
  PRIMARY KEY (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci


CREATE TABLE movies_genres (
        movie_id INT UNSIGNED NOT NULL,
        genre_id INT UNSIGNED NOT NULL,
        FOREIGN KEY (movie_id) REFERENCES movies(id),
        FOREIGN KEY (genre_id) REFERENCES genres(id)
    );
SHOW CREATE TABLE movies_genres;


Table
Create Table


movies_genres
CREATE TABLE `movies_genres` (
  `movie_id` int unsigned NOT NULL,
  `genre_id` int unsigned NOT NULL,
  KEY `movie_id` (`movie_id`),
  KEY `genre_id` (`genre_id`),
  CONSTRAINT `movies_genres_ibfk_1` FOREIGN KEY (`movie_id`) REFERENCES `movies` (`id`),
  CONSTRAINT `movies_genres_ibfk_2` FOREIGN KEY (`genre_id`) REFERENCES `genres` (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci