I have a zip containing 3
1::Toy Story (1995)::Animation|Children's|Comedy
I was wondering if there was any command in MySQL that would read the file and create a Table automatically with those column names.
No you will have to create the tables yourself. This is because it's very hard for mysql (or any other database) to figure out what your column data types ought to be. Table creation is easy. For example the movies table might be something like:
CREATE TABLE movies( movie_id INT NOT NULL AUTO_INCREMENT PRIMARY KEY, title VARCHAR(255), genre VARCHAR(255))
The current approach of saving multiple geners in one column is sub optimal. You ought to read up on database normalization as well.
Once you have created the tables, you can load the data with LOAD DATA