MySql
文章平均质量分 89
mysql学习笔记问题汇总
ForeverAnt
这个作者很懒,什么都没留下…
展开
-
centos7离线安装Mysql5.7
1.去官网下载mysql2.创建安装目录mkdir /usr/local/mysql/3.ftp上传安装包至 /usr/local/mysql/下4.解压至安装目录tar -xvf mysql-5.7.34-1.el7.x86_64.rpm-bundle.tar5.查询预装的mariadbrpm -qa | grep -i mariadb6.删除mariadbyum remove mariadb-libs-5.5.44-2.el7.centos.x86_647.安装解转载 2021-07-19 16:23:36 · 342 阅读 · 0 评论 -
Mysql根据拼音首字母分组和排序
最近业务上有个需求,需要根据英文字母展示对应的人名图示这样的:和我们手机的通讯录差不多通常如果表设计的时候增加了对应的首字母字段应该很好实现,那如果没加,应该怎么实现呢!1.图示SqlSELECT name,ELT( INTERVAL ( CONV( HEX( LEFT ( CONVERT (NAME USING gbk), 1 ) ), 16, 10 ), 0xB0A1, 0xB0C5,转载 2020-12-23 18:24:36 · 1861 阅读 · 1 评论 -
MySql5.7[Err] 1055 - Expression #1 of ORDER BY clause is not in GROUP BY clause and contains nonaggr
如题。MySQL5.7每次执行Sql语句都会出现[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 in GROUP BY clause; this is incompatible w原创 2020-09-25 10:48:33 · 327 阅读 · 0 评论 -
MySQL8.0.16win10.zip版安装流程
首先去mysql官网(https://www.mysql.com/downloads/)下载mysql最新版本1.选择如图所示 community2.点击图示 download3.解压到指定盘中例:F:\mysql8.0.164.配置环境变量MYSQL_HOME:F:\mysql8.0.16`在path 后面添加 ;%MYSQL_HOME%\bin5.添加文件my.ini文件6...转载 2019-05-23 22:29:15 · 1946 阅读 · 0 评论