Importing PATSTAT 2024b into MySQL

Imports the European Patent Office (EPO) 2024b database PATSTAT (https://www.epo.org/en/searching-for-patents/business/patstat) into MySQL.

Instructions

Unzip every tlsXXX_partYY.zip found in the PATSTAT archives into a single folder.
Run 01_create_DB_and_tables.sql to create the database and tables.
Open 02_import_data_files.sql and change the SET PATH TO DATA FOLDER chunk to the directory containing the unzipped PATSTAT csv files. you may want to uncomment some of the sections in this code.
Run 02_import_data_files.sql to import the data. This may take some time. You may want to comment out unneeded tables.
Run 03_row_counts.sql to check if the row counts match the ones reported by PATSTAT.
Run 04_indexation.sql to create indices. You may want to modify this according to your own needs.

Name		Name	Last commit message	Last commit date
Latest commit History 7 Commits
01_create_DB_and_tables.sql		01_create_DB_and_tables.sql
02_import_data_files.sql		02_import_data_files.sql
03_row_counts.sql		03_row_counts.sql
04_indexation.sql		04_indexation.sql
README.md		README.md