How to write 2 csv files in MySQL?

Question

MySQL

Hello. There are two files: movies.csv and rating.csv with 10,000 and 100,000 lines respectively:
movies.csv looks like this:

movieId,title,genres
1,Toy Story (1995),Adventure|Animation|Children|Comedy|Fantasy
2, Jumanji (1995),Adventure|Children|Fantasy
3,Grumpier Old Men (1995),Comedy|Romance
4,Waiting to Exhale (1995),Comedy|Drama|Romance
5,Father of the Bride Part II (1995),Comedy
6 ,Heat (1995),Action|Crime|Thriller
7,Sabrina (1995),Comedy|Romance
8,Tom and Huck (1995),Adventure|Children
9,Sudden Death (1995),Action
...

rating.csv looks like this :

userId,movieId,rating,timestamp
1,1,4.0,964982703
1,3,4.0,964981247
1.6.4.0.964982224
1.47.5.0.964983815
2.50.5.0.964982931
_
_
_
_
_

_ basic level and SQL (I know how to write queries)

how to create a database that will store two tables: movies and rating?
after i have a database with two tables movies and rating, how to work with this database?
what do you need to do to start working with the database?
Thanks in advance