mysql常用命令

目录

启动mysql

进入mysql命令行

通过命令行设置全局参数

解决使用group by报错问题

---

启动mysql

进入mysql命令行

cd D:\environment\mysql\mysql-8.0.32-winx64\bin

 mysql -uroot -p

通过命令行设置全局参数

set global tmp_table_size = 512*1024*1024;

set global transaction isolation level read committed;

set global innodb_buffer_pool_size=4096*1024*1024; 

set global max_allowed_packet = 64*1024*1024;

解决使用group by报错问题

(189条消息) 1055 - Expression #1 of SELECT list is not in GROUP BY clause and contains nonaggregated column ‘tab_徊忆羽菲的博客-CSDN博客 

(189条消息) 1055 - Expression #1 of SELECT list is not in GROUP BY clause and contains nonaggregated column ‘tab_徊忆羽菲的博客-CSDN博客