MySQL Forums
Forum List  »  GIS

Re: Mysql 5.7.27 ST_INTERSECTS Problem
Posted by: Fantasy Black
Date: November 04, 2022 10:33AM

Here the create sql:

CREATE TABLE IF NOT EXISTS geom_test (
id BIGINT AUTO_INCREMENT PRIMARY KEY,
data_id BIGINT,
geom BLOB
);
INSERT INTO geom_test (data_id, geom) VALUES (1, GEOMFROMTEXT('POLYGON((0 0,0 1,1 1,0 1,0 0))'))
INSERT INTO geom_test (data_id, geom) VALUES (2, GEOMFROMTEXT('POLYGON((0 0,0 1,1 1,0 1,0 0))'))
SELECT * FROM geom_test WHERE ST_INTERSECTS(geom, GEOMFROMTEXT('POLYGON((0 0,0 2,1 1,0 1,0 0))'))

Options: ReplyQuote


Subject
Views
Written By
Posted
77
November 04, 2022 10:29AM
Re: Mysql 5.7.27 ST_INTERSECTS Problem
60
November 04, 2022 10:33AM


Sorry, only registered users may post in this forum.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.