1-nconst | 2-primaryName | 3-birthYear | 4-deathYear 5-primaryProfession | 6-knownForTitles

LOAD DATA LOCAL INFILE '/root/name.basics.tsv' INTO TABLE name_basics IGNORE 1 ROWS (@col1, @col2, @col3, @col4, @col5, @col6) SET nconst = @col1, primaryName = @col2, birthYear = @col3, deathYear = @col4;

----

1-titleId | 2-ordering | 3-title | 4-region | 5-language | 6-types | 7-attributes | 8-isOriginalTitle

LOAD DATA LOCAL INFILE '/root/title.akas.tsv' INTO TABLE title_akas IGNORE 1 ROWS (@col1, @col2, @col3, @col4, @col5, @col6, @col7, @col8) SET titleId = @col1, ordering = @col2, title = @col3, region = @col4;

----

1-tconst | 2-titleType | 3-primaryTitle | 4-originalTitle | 5-isAdult | 6-startYear | 7-endYear | 8-runtimeMinutes | 9-genres

LOAD DATA LOCAL INFILE '/root/title.basics.tsv' INTO TABLE title_basics IGNORE 1 ROWS (@col1, @col2, @col3, @col4, @col5, @col6, @col7, @col8, @col9) SET tconst = @col1, primaryTitle = @col3, startYear = @col6, endYear = @col7, genres = @col9;

----

1-tconst | 2-parentTconst | 3-seasonNumber | 4-episodeNumber

LOAD DATA LOCAL INFILE '/root/title.episode.tsv' INTO TABLE title_episode IGNORE 1 ROWS (@col1, @col2, @col3, @col4) SET tconst = @col1, parentTconst = @col2;

----

1-tconst | 2-ordering | 3-nconst | 4-category | 5-job | 6-characters

LOAD DATA LOCAL INFILE '/root/title.principals.tsv' INTO TABLE title_principals IGNORE 1 ROWS (@col1, @col2, @col3, @col4, @col5, @col6) SET tconst = @col1, ordering = @col2, nconst = @col3, category = @col4, characters = @col6;

----

1-tconst | 2-averageRating | 3-numVotes

LOAD DATA LOCAL INFILE '/root/title.ratings.tsv' INTO TABLE title_ratings IGNORE 1 ROWS (@col1, @col2, @col3) SET tconst = @col1, averageRating = @col2, numVotes = @col3;