Mysql show processlist 进程删除

登录mysql show processlist; 删除进程方法: kill 进程id; 快捷点的方法 select concat('KILL ',id,';') from information_schema.processlist where state= 'updating'; //根据状态查询

Redis 命令

Redis主要有五种数据类型:string(字符串),hash(哈希),list(列表),set(集合)及zset(sorted set:有序

Walle 2.0 安装使用

walle 让用户代码发布终于可以不只能选择 jenkins!支持各种web代码发布,php、java、python、go等代码的发布、回滚可以通过we

Mysql SELECT list is not in GROUP BY clause

问题 Expression #7 of SELECT list is not in GROUP BY clause and contains nonaggregated column 'bestshop.ya_promotion.mobile' which is not functionally dependent on columns in GROUP BY clause; this is incompatible with sql_mode=only_full_group_by 临时解决方法: set global sql_mode='STRICT_TRANS_TABLES,NO_ZERO_IN_DATE,NO_ZERO_DATE,ERROR_FOR_DIVISION_BY_ZERO,NO_AUTO_CREATE_USER,NO_ENGINE_SUBSTITUTION'; set session sql_mode='STRICT_TRANS_TABLES,NO_ZERO_IN_DATE,NO_ZERO_DATE,ERROR_FOR_DIVISION_BY_ZERO,NO_AUTO_CREATE_USER,NO_ENGINE_SUBSTITUTION'; 永久解决方法 修改mysql的配置文件里面的sq