qq_20142511的博客

执行语句select brand as 品牌,carid as 数量 from car group by brand;报错 ERROR 1055 (42000): Expression #2 of SELECT list is not in GROUP BY clause and contains nonaggregated column 'car.car.carid' which is ...

一. 启动federated引擎： 在mysql8上开启federated引擎的方式稍微有点不同，分两步： 1. sudo vim /etc/mysql/mysql.conf.d/mysqld.cnf 文件中加入federated一行； 2. systemctl restart mysql.service 重启mysql； 3. su - mysql //这是Linux的mys...