I am a BA type (no programming expertise) helping a NFP NGO create a Food website.
I have recently converted from MySQL to Maria (10.7, X64) and use Heidi (188.8.131.5295) as the interface.
In MySQL, I used the following script to geo-code 107K Providores (farmers, grower, producers, etc):
ALTER TABLE prov_au ADD Location Point:
ALTER TABLE prov_au MODIFY Location POINT NOT NULL; and it took a few seconds to create the Geometry field in the Location field.
This is used for mapping, calculating food miles, etc.
I did manage to geo-code a smaller Maria DB (11K records) with a script similar to this:
ALTER TABLE vic_rural ADD Location Point;
INSERT INTO vic_rural VALUES (GeomFromText ('POINT(longitude, latitude)'));
Not sure how, but it (or some script similar worked - and without a 'where' clause - see below.
But have not been able to replicate this, as Heidi now requires me to add a 'where' clause somewhere in the Query script, which is beyond my knowledge.