I want to store WGS84 coordinates in a MySQL 5.7 database. After much reading, I think I should use the POINT datatype with a SPATIAL INDEX. But I am very confused about SRSs, SRIDs, lat/long vs long/lat, etc.
Could someone give me a very simple example of how I would create a table with
coordinates columns that would correctly store a string location name, and lat/long values in decimal degrees?
And then, an example of how I would insert data into this table correctly?
I am reading conflicting information on what SRID I should use (0? 4326?) in order to do distance calculations correctly. Also reading conflicting information on whether it should be POINT(lat, long) or POINT(long, lat).