srid srs_attribute  ... srs_attribute : { NAME ’ srs_name ’ | DEFINITION ’ definition ’ | ORGANIZATION ’ org_name ’ IDENTIFIED BY org_id | DESCRIPTION ’ description ’ } srid , org_id : 32-bit unsigned integer 

This statement creates a spatial reference system (SRS) definition and stores it in the data dictionary. It requires the SUPER  privilege. The resulting data dictionary entry can be inspected using the INFORMATION_SCHEMA ST_SPATIAL_REFERENCE_SYSTEMS  table. 

SRID values must be unique, so if neither OR REPLACE  nor IF NOT EXISTS  is specified, an error occurs if an SRS definition with the given srid  value already exists. 

With CREATE OR REPLACE  syntax, any existing SRS definition with the same SRID value is replaced, unless the SRID value is used by some column in an existing table. In that case, an error occurs. For example: 

mysql> CREATE OR REPLACE SPATIAL REFERENCE SYSTEM 4326 ...; ERROR 3716 (SR005): Can’t modify SRID 4326. There is at least one column depending on it. 

To identify which column or columns use the SRID, use this query, replacing 4326 with the SRID of the definition you are trying to create: 

SELECT * FROM INFORMATION_SCHEMA.ST_GEOMETRY_COLUMNS WHERE SRS_ID=4326; 

With CREATE ... IF NOT EXISTS  syntax, any existing SRS definition with the same SRID value causes the new definition to be ignored and a warning occurs. 

SRID values must be in the range of 32-bit unsigned integers, with these restrictions: 

•SRID 0 is a valid SRID but cannot be used with CREATE SPATIAL REFERENCE SYSTEM . 

•If the value is in a reserved SRID range, a warning occurs. Reserved ranges are [0, 32767] (reserved by EPSG), [60,000,000, 69,999,999] (reserved by EPSG), and [2,000,000,000, 2,147,483,647] (reserved by MySQL). EPSG stands for the European Petroleum Survey Group. 

•Users should not create SRSs with SRIDs in the reserved ranges. Doing so runs the risk of the SRIDs conflicting with future SRS definitions distributed with MySQL, with the result that the new system- provided SRSs are not installed for MySQL upgrades or that the user-defined SRSs are overwritten. 

Attributes for the statement must satisfy these conditions: 

•Attributes can be given in any order, but no attribute can be given more than once. 

•The NAME  and DEFINITION  attributes are mandatory. 

•The NAME srs_name  attribute value must be unique. The combination of the ORGANIZATION org_name  and org_id  attribute values must be unique. 

•The NAME srs_name  attribute value and ORGANIZATION org_name  attribute value cannot be empty or begin or end with whitespace. 

•String values in attribute specifications cannot contain control characters, including newline. 

