Tool for import PATSTAT into MySQL

Here you can post your opinions, ask questions and share experiences on the PATSTAT product line. Please always indicate the PATSTAT edition (e.g. 2015 Autumn Edition) and the database (e.g. PATSTAT Online, MySQL, MS SQL Server, ...) you are using.
Post Reply

Posts: 114
Joined: Wed Sep 04, 2013 6:17 am
Location: Vienna

Tool for import PATSTAT into MySQL

Post by mkracker » Fri Dec 18, 2015 5:44 pm

Many of the PATSTAT Raw Data users work on MySQL.

Recently I was in contact with Simone Mainardi (, who created a handy tool to upload the PATSTAT Raw Data files into MySQL. Simone is happy to share his effort with the community and recently upgraded it to be compatible with the current PATSTAT 2015 Autumn edition.

The tool is called load_patstat and can be accessed via GitHub:

In other recent posts you can also find more import scripts for MySQL as well as for Postgresql. I applaud and thank all of them for their contribution..
Martin Kracker / EPO

Posts: 14
Joined: Mon Nov 16, 2015 2:13 am

Re: Tool for import PATSTAT into MySQL

Post by Rachie » Wed Dec 23, 2015 7:34 pm

Wonderful! Thanks so much, Simone.

Post Reply