What data type should be used in sql to indicate genres for example?

Question

SQL

If I want to put several different values ​​​​in 'genres' - action, thriller, drama, etc.

Answer 1

A many-to-many relationship is used in such cases.

Answer 2

integer:

create table genres (
  	id int primary key auto_increment,
  	name varchar(255)
);

create table films (
  id int primary key auto_increment,
  	name varchar(255)
);

create table film_genres (
  film_id int,
  	genre_id int
);

SQL fiddle

Answer 3

Look here .
Potentially not too much data to worry about the size of both the movie table and the genre table.

Answer 4

In Postgresql, you can make an array of enams.
True, I xs how it will be with indexing.
The most common option is to make a table with genres and make a Many-to-Many relationship between it and the table with movies. It will be just another intermediate table with movie ID and genre ID.
Slava Rozhnev gave a code example for such a case..