ht a
table like that, and paste it into Excel. That darn Microsoft -- they think
of everything! :) Thanks for the tip.
-Original Message-
From: Nuno Tavares [mailto:nuno.tava...@dri.pt]
Sent: Wednesday, October 03, 2012 3:10 PM
To: mysql@lists.mysql.com
Subject: Re: need list of country I
ave
Thanks for the tip.
-Original Message-
From: Nuno Tavares [mailto:nuno.tava...@dri.pt]
Sent: Wednesday, October 03, 2012 3:10 PM
To: mysql@lists.mysql.com
Subject: Re: need list of country ISO code to demonyms
I don't have it, sorry.
But it took me 10 seconds to copy & pas
Wednesday, October 03, 2012 3:10 PM
> To: mysql@lists.mysql.com
> Subject: Re: need list of country ISO code to demonyms
>
> I don't have it, sorry.
>
> But it took me 10 seconds to copy & paste it to an Excel, so I could
> save it as CSV and import it directly to M
I don't have it, sorry.
But it took me 10 seconds to copy & paste it to an Excel, so I could
save it as CSV and import it directly to MySQL. Further on, it'd be as
simples as JOIN by name with a table with ISO-to-country-names, which
you can fetch in hundreds of places, such as Wikipedia.
-N
Anyone have a SQL dump or other programmatically useable map of country ISO
codes to demonyms?
http://www.geography-site.co.uk/pages/countries/demonyms.html
I can parse the strings I suppose there, but that's not quite as accurate,
and ripping that out of the HTML page to parse seems painful too.