![](https://img-blog.csdnimg.cn/20201014180756928.png?x-oss-process=image/resize,m_fixed,h_64,w_64)
mysql
很直的直男癌
这个作者很懒,什么都没留下…
展开
-
centos7 rpm 安装mysql
yum install perl -yyum install libaio -yyum install net-tools -yyum install numactl -y修改默认密码ALTER USER 'root'@'localhost' IDENTIFIED BY 'new_password';ALTER USER user() IDENTIFIED BY 'new_password';原创 2020-06-16 14:23:43 · 160 阅读 · 0 评论 -
mysql-行列转换
-------注意sum函数 是统计合-------select name,sum(case when course='java' then grade end) as java,sum(case when course='C++' then grade end) as C++,sum(case when course='C#' then grade end) as C#from...原创 2017-04-09 11:45:34 · 2822 阅读 · 1 评论