Caution: This ticket is a rather technical (you're warned from the start). As
Kappa has a geolocation part, I have a table that includes cities for now all the cities of France (DOM-TOM included) with their coordinates (latitude, longitude). There are currently only French cities, but as I plan to open Kappa other countries (like, a revelation), I of course a field which is a country CHAR ( 2) and is indexed. Although
. The scene is set. Let's see what is mysterious ...
mysql> SELECT COUNT (*) FROM cities;
+----------+
If ever a pro MySQL goes by that I do not mind some light.
0 comments:
Post a Comment