在建立表之后插入数据,发现插入时报错
INSERT INTO bridges VALUES(110,'卡姆桥',102,103, PointFromText('POINT(44,31)',101));
修改为
INSERT INTO bridges VALUES(110,'卡姆桥',102,103, ST_PointFromText('POINT(44,31)',101));
就可以查询成功了。
在建立表之后插入数据,发现插入时报错
INSERT INTO bridges VALUES(110,'卡姆桥',102,103, PointFromText('POINT(44,31)',101));
修改为
INSERT INTO bridges VALUES(110,'卡姆桥',102,103, ST_PointFromText('POINT(44,31)',101));
就可以查询成功了。