mysql 存储坐标数组

CREATE TABLE locations (
    id INT PRIMARY KEY,
    coordinates TEXT
);

INSERT INTO locations (id, coordinates) VALUES (1, '[[120.123, 30.456], [120.789, 31.123]]');

CREATE TABLE locations (
    id INT PRIMARY KEY,
    lat1 FLOAT,
    lon1 FLOAT,
    lat2 FLOAT,
    lon2 FLOAT
);

INSERT INTO locations (id, lat1, lon1, lat2, lon2) VALUES (1, 30.456, 120.123, 31.123, 120.789);

CREATE TABLE locations (
    id INT PRIMARY KEY,
    coordinates POINT NOT NULL SRID 4326
);

INSERT INTO locations (id, coordinates) VALUES (1, POINT(120.123, 30.456));

SELECT id, JSON_EXTRACT(coordinates, '$[0]') AS point1, JSON_EXTRACT(coordinates, '$[1]') AS point2 FROM locations WHERE id = 1;

SELECT id, (lat1, lon1) AS point1, (lat2, lon2) AS point2 FROM locations WHERE id = 1;

SELECT id, ST_AsText(coordinates) AS coordinates FROM locations WHERE id = 1;