Saturday, July 9, 2016

Mysql upload scripts for patstat 2016a

Following the release of patstat 2016a, at this link

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.