夏虫不可语寒的博客

MySql常见优化收集（一）1.建表1.1表结构CREATE TABLE `t` ( `id` bigint NOT NULL AUTO_INCREMENT, `mobile` bigint DEFAULT NULL, `PASSWORD` varchar(64) COLLATE utf8mb4_general_ci DEFAULT NULL, `username` varchar(64) COLLATE utf8mb4_general_ci DEFAULT NULL, `sex`

常用MySQL总结1.查询表select * from tablename;2.修改表添加列alter table tablename add col char(20);删除列alter table tablename drop column col;删除表drop table tablename;3.插入普通插入insert into tablename(col1,col2) value (val1,val2);插入查询结果insert into tablename

#首先查看对应的线程show processlist;#记住对应的idselect * from `performance_schema`.events_current where THREAD_ID=刚才的id#也可以范围查找select * from `performance_schema`.events_current where THREAD_ID>=刚才的id#查出来后，字段SQL_TEXT就是该线程对应的sql语句...

# which mysql/usr/bin/mysql# /usr/bin/mysql --verbose --help|grep -A 1 'Deafult options'....

1.解决返回值为null的问题//假设name,addr返回的值中可能存在null值select id,name,addr from tabe1 where id=1;//修改的后的sql为select id,case when name is null then '' else name end as name,case when addr is null then '' else addr end as addrfrom tabe_name where id=1;2.

该sql可以向null字段追加数据update table set 字段名=case when 字段名 is not null then CONCAT(字段名,"追加的数据") else "追加的数据" end where id=1;如果字段默认值为空串可以使用以下sql：update table set 字段名=CONCAT(字段名,"追加的数据") where id=1;case when then else end的初次探索...

一、准备1、建议使用国内的mysql镜像下载//搜狐的镜像wegt http://mirrors.sohu.com/mysql/MySQL-5.7/mysql-5.7.24-linux-glibc2.12-x86_64.tar.gz//中国科学技术大学开源软件镜像wegt http://mirrors.ustc.edu.cn/mysql-ftp/Downloads/MySQL-5.7/m...