mysql
cs95
这个作者很懒,什么都没留下…
展开
-
阿里云 centos 7.6 安装MySql数据库 以及 本地连接MySql数据库
安装MySql数据库 1.下载并安装MySQL官方的Yum Repository #wget -i -c http://dev.mysql.com/get/mysql57-community-release-el7-10.noarch.rpm 2.安装 # yum -y install mysql57-community-release-el7-10.noarch.rpm 3.安装MySQL服务器 # yum -y install mysql-community-server 4.启动MyS.原创 2020-06-04 23:04:56 · 546 阅读 · 0 评论 -
解决[Err] 1055 - Expression #1 of ORDER BY clause is not in GROUP BY clause and contains...报错
结果报[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 with sql_mode=only_full_原创 2020-06-09 16:43:10 · 782 阅读 · 0 评论 -
mysql alter 用法/修改表/字段
1.修改表名 alter table test_a rename to sys_app; 2.修改表注释 alter table sys_application comment '系统信息表'; 二:修改字段信息 1.修改字段类型和注释 alter table sys_application modify column app_name varchar(20) COMMENT '应用的名称'; 2.修改字段类型 alter table sys_applicatio...原创 2020-06-10 15:41:38 · 251 阅读 · 0 评论