title: Is there somewhere a Yaml or SQL insert list of all countries?
body: <blockquote>
    <p><strong>Possible Duplicate:</strong><br>
    <a href="https://stackoverflow.com/questions/1788950/where-can-i-get-a-list-of-all-countries-cities-to-populate-a-listbox">Where can I get a list of all countries/cities to populate a listbox?</a>  </p>
  </blockquote>
  
  
  
  <p>I am looking for a script to create all the countries. Somebody knows an free ISO list i can easily use in Ruby?</p>
  
  <p>I can find lists on google but I am not lucky with a yaml, csv or SQL inserts.</p>
  
  <p>I am also very interested in all the cities in Spain.</p>
  
  <p>EDIT: Countries + Country code</p>
  
  <p>Edit2: Just interested in all cities of Spain.</p>