[QUICKTIPS] MySQL spatial data
It’s MySQL spatial data week here, though I am spreading out the posts to, um, ease the pain (or boredom). Anyway, here are some commands/functions I don’t want to forget about later: Start with an existing table called geometry, add a spatial column and index it: ALTER TABLE geometry ADD coord POINT NOT NULL; CREATE SPATIAL INDEX coord ON geometry (coord); Insert... Read More
