[MySQL] mysql地理位置服务geometry字段类型

这个字段类型是mysql5.7新增的功能,主要就是解决坐标存储和距离计算的常见问题

创建表:
create table `rvice` (
`id` bigint(20) not null auto_increment,
`name` varchar(128) not null defa未来的机器人作文ult ”,
`content` varchar(128) not null default ”,
`tel` varchar(20) not null default ”,
`location` geometry not null,
primary key (`id`),
key `location` (`location`(32))
) engine=innodb auto_increment=1 default ch学校办公室主任工作总结art=utf8

插入坐标
inrt into rvice (name,content,tel,location)values(“陶士涵”,’牛逼’,’18898989898′,st_geomfromtext(‘point(116.28828 40.053257)’));
读取坐标lock是什么意思
lect *,astext(location) from rvice;
查询距离
lect name,content,tel, (st_distance (location,point(116.282459,40.047955) ) *111195) as distance from rvice order by distance;
判风和断距离
lect name,content,tel,a龙梅子个人资料stext(location),floor(st_distance (location,point(116.282459,40.047955) ) *111195) as distance from rvice having distance < 1000 order by distance;