![](https://img-blog.csdnimg.cn/20201014180756757.png?x-oss-process=image/resize,m_fixed,h_64,w_64)
Mysql
文章平均质量分 75
站在墙头上
挣不到钱,只能发奋图强好好学习
展开
-
两个命令安装一个mysql:docker安装mysql5.7
docker安装mysql原创 2023-05-29 15:53:40 · 587 阅读 · 0 评论 -
MySQL空间函数ST_Distance_Sphere()的使用
MySQL空间函数ST_Distance_Sphere(g1, g2 [, radius]) :返回球体上两个点和/或多点之间的最小球面距离(以米为单位)官网(https://dev.mysql.com/doc/refman/5.7/en/spatial-convenience-functions.html)测试表结构如下:create table t_geo_test( ID...原创 2020-02-20 10:31:37 · 22432 阅读 · 2 评论 -
MySQL插入数据报错(Incorrect string value: '\xE7\xA8\x8B\xE5\xBA\x8F...' for column 'course' at row 1)
创建表语句:create table AddressHistory( _id varchar(32) not null, address varchar(200) null, createTime datetime null, location geometry not null, phone bigi...原创 2020-02-19 10:02:42 · 649 阅读 · 0 评论 -
[Err] 1055 - Expression #1 of ORDER BY clause is not in GROUP BY clause and contains nonaggregated
MySQL更新报错:[Err] 1055 - Expression #1 of ORDER BY clause is not in GROUP BY clause and contains nonaggregated column ‘information_schema.PROFILING.SEQ’ which is not functionally dependent on columns i...原创 2019-12-22 15:33:13 · 166 阅读 · 0 评论 -
CentOS7环境安装 MySQL5.7
通过下载yum源的方式进行安装1、下载yum源下载:rpm -Uvh https://repo.mys`ql.com//mysql57-community-release-el7-11.noarch.rpm查看mysql的安装文件yum repolist enabled | grep "mysql.*-community.*"2、开始安装安装命令yum install my...原创 2019-11-30 01:00:26 · 362 阅读 · 1 评论