Skip to content

Instantly share code, notes, and snippets.

@ozgurozkok
Created January 30, 2023 16:21
Show Gist options
  • Save ozgurozkok/d63fff8e41518f6ef2ca7ce2a389bb31 to your computer and use it in GitHub Desktop.
Save ozgurozkok/d63fff8e41518f6ef2ca7ce2a389bb31 to your computer and use it in GitHub Desktop.
SRID example in MYSQL
CREATE TABLE places (
id INT PRIMARY KEY,
name VARCHAR(100),
location POINT,
SRID INT
);
INSERT INTO places (id, name, location, SRID)
VALUES (1, 'Place A', ST_GeomFromText('POINT(1 1)', 4326), 4326);
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment