
mysql
很直的直男癌
这个作者很懒,什么都没留下…
展开
-
centos7 rpm 安装mysql
yum install perl -y yum install libaio -y yum install net-tools -y yum install numactl -y 修改默认密码 ALTER USER 'root'@'localhost' IDENTIFIED BY 'new_password'; ALTER USER user() IDENTIFIED BY 'new_password';原创 2020-06-16 14:23:43 · 206 阅读 · 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 · 2847 阅读 · 1 评论