![](https://img-blog.csdnimg.cn/20190918140129601.png?x-oss-process=image/resize,m_fixed,h_224,w_224)
数据库
文章平均质量分 69
数据库
豆沙睡不醒
永远不要停下脚步
展开
-
【MySQL】MySQL索引的定义、分类、Explain、索引失效和优化
MySQL索引的定义、分类、Explain、索引失效和优化原创 2023-09-16 10:55:59 · 383 阅读 · 1 评论 -
【MySQL8.0】【Junit】Access denied for user ‘‘@‘localhost‘ + Internal Error occurred.
Internal Error occurred.报错信息org.junit.platform.commons.JUnitException: TestEngine with ID ‘junit-vintage’ failed to discover tests at org.junit.platform.launcher.core.EngineDiscoveryOrchestrator.discoverEngineRoot(EngineDiscoveryOrchestrator.java:160)原创 2022-04-25 21:12:00 · 348 阅读 · 0 评论 -
【MySQL8.0】ERROR 2003 (HY000) + ERROR 1820 (HY000) + 命令行导入SQL
ERROR 2003 (HY000): Can’t connect to MySQL server on ‘localhost:3306’ (10061)昨天刚修好了今天发现又这样了发现可能MySQL服务没启动,用net start mysql启动服务ERROR 1820 (HY000): You must reset your password using ALTER USER statement before executing this statement.新注册以后发现要修改密码才能进原创 2022-04-25 10:01:18 · 874 阅读 · 0 评论 -
【SQL】牛客题霸SQL入门篇1(基础查询、条件查询、高级查询)
链接基础查询SQL1查询多列select device_id,gender,age,university from user_profile;SQL2 查询所有列select * from user_profile;SQL3 查询结果去重select distinct university from user_profile;SQL4 查询结果限制返回行数select device_id from user_profile where id<=2;select device_原创 2022-03-03 17:58:16 · 465 阅读 · 0 评论