Saturday, July 9, 2016

Mysql upload scripts for patstat 2016a

Following the release of patstat 2016a, at this link

https://dl.dropboxusercontent.com/u/3004945/rawpatentdata/patstat2016a.rar

it's possible to download my scripts for mysql allowing to upload the majority of tables from ediction 2016a of patstat;

Please note I uploaded the new TLS906 in TLS206 in order to make smoother the db steps that follow the import of patstat data.

Also changed CHARACTER SET to utf8mb4 COLLATE utf8mb4_general_ci following EPO suggestions.