This is an example of how to add the city West Melbourne which is located in USA Florida, county code can be obtained by filter any other city from Florida in the cities table, and the city value is incremented by 1 on the last city in the table value.
insert into cities (city,country,state,name,county_code) values('46769','USA','FL','West Melbourne','299');