![](https://img-blog.csdnimg.cn/20201014180756918.png?x-oss-process=image/resize,m_fixed,h_64,w_64)
MySQL
Jsoooo
这个作者很懒,什么都没留下…
展开
-
Linux下 mysql 忘记密码或access denied
解决: 1.先关闭mysql服务 # service mysql stop 2.用安全模式进入: # mysqld_safe --user=mysql --skip-grant-tables --skip-networking & 后台运行 3.然后直接免密进入mysql: # mysql -uroot 4.更改mysql密码: mysql> UPDATE mysql.user SE...原创 2018-10-29 13:02:11 · 511 阅读 · 0 评论 -
SQL 各种join
转自: https://www.cnblogs.com/grandyang/p/5346963.html转载 2018-11-06 15:18:58 · 78 阅读 · 0 评论 -
Java-MySQL索引
1.B-Tree索引 1.使用方法: CREATE TABLE t( aid int unsigned not null auto_increment, userid int unsigned not null default 0, username varchar(20) not null default ‘’, detail varchar(255) not nul...原创 2019-03-07 14:58:40 · 606 阅读 · 0 评论 -
SQL练习
参考答案: select t.std_nm, t.class, t.score, t.od from (select std_nm, class, score, row_number() over (partition by class order by score desc) as od from pub_f_class_score)t where od<=3; Select...原创 2019-04-12 19:55:23 · 125 阅读 · 0 评论 -
SQL-查询语句执行顺序
SQL语句执行顺序 (8)SELECT (9) DISTINCT (11) (1) FROM (3) JOIN (2) ON (4) WHERE (5) GROUP BY (6) WITH {CUBE | ROLLUP} (7) HAVING (10) ORDER BY 1)FROM:对FROM子句中的表执行笛卡尔积(交叉联接),生成虚拟表VT1。 2)ON:对VT1应用ON...原创 2019-08-09 20:50:54 · 201 阅读 · 0 评论