Created
January 30, 2023 16:21
-
-
Save ozgurozkok/d63fff8e41518f6ef2ca7ce2a389bb31 to your computer and use it in GitHub Desktop.
SRID example in MYSQL
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
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