MySQL world countries table

BeediaFiegoni4

New Member
What I need is, MySQL table with following fields:
  • Country name
  • Country name's code (like uk for United Kingdom)
  • Nationality (like Russian for Russia)
  • official language (like arabic for UAE)
for all world countries. After deep search in google found this result, http://publications.europa.eu/code/en/en-5000500.htm which is ideal for if it had official language column and MYSQL dump. But can't find. Also this one generates mysql but has no required columns: http://peric.github.io/GetCountries/ Maybe someone has ready table.Can anyone help me with this problem?
 
Top