liutest_926的博客

表，单字段重复删除deletefrom studentwhere id not in( select a.id from ((select min(id) id from student group by (name))a));表中，多字段重复 匹配删除数据，创建一个临时表tmp,存入最大id一个数据，数据唯一删除不是tmp表id其他所有值删除临时tmp表crea...

[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_gro

centos7 MySQL安装之前都没有记录，时间久了都不太记得了，安装的时候还得重新找，这次记录下，方便以后查看。直接下载，或者从本地下载后再上传到服务器上。[root@localhost backup]# wget https://cdn.mysql.com//Downloads/MySQL-5.7/mysql-5.7.29-1.el7.x86_64.rpm-bundle.tar解压：[root@localhost backup]# tar -xvf mysql-5.7.29-1.e