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.
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.
1 comment:
Hi Gianluca,
I'm trying to upload patstat, using MySQL Workbench (in which I am completely novice).
When trying to run the first line of your code, an error 1049 occurs (unknown database "patstat")
I guess this is because the software cannot find the raw csv patstat files right ? I guess I should save them somewhere, but where ? And also, should I save the compressed files, or extract and save each of the raw csv files ?
Thank you in advance !
Best,
L
Post a Comment