HA! No $hit! Well isn't that clever. I didn't know that you can highlight 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 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 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. > > -NT > > > Em 03-10-2012 22:22, Daevid Vincent escreveu: > > 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. > > > > > -- > MySQL General Mailing List > For list archives: http://lists.mysql.com/mysql > To unsubscribe: http://lists.mysql.com/mysql -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/mysql