![](https://img-blog.csdnimg.cn/20201014180756780.png?x-oss-process=image/resize,m_fixed,h_64,w_64)
MySQL
文章平均质量分 83
巨輪
How many ten years are in left time?
展开
-
MySQL优化学习笔记
----一、MySQL架构介绍-01_课程简介02_MySQL简介03_RPM安装04_ROOT密码设置和开机自启动05_安装位置06_修改字符集07_MySQL配置文件08_MySQL逻辑架构简介09_存储引擎简介-二、索引优化分析-10_SQL性能下降原因11_SQL执行加载顺序12_七种JOIN理论13_七种JOIN的SQL编写14_索引是什么15_索引优劣势16_索引分类和建索引命令语句17_索引结构与检索...原创 2021-04-06 20:41:07 · 12025 阅读 · 3 评论 -
LeetCode - Easy - 196. Delete Duplicate Emails
TopicSQLDescriptionhttps://leetcode.com/problems/delete-duplicate-emails/Write a SQL query to delete all duplicate email entries in a table named Person, keeping only unique emails based on its smallest Id.+----+------------------+| Id | Email原创 2020-12-24 20:09:42 · 198 阅读 · 1 评论 -
LeetCode - Easy - 182. Duplicate Emails
TopicEasyDescriptionhttps://leetcode.com/problems/duplicate-emails/Write a SQL query to find all duplicate emails in a table named Person.+----+---------+| Id | Email |+----+---------+| 1 | a@b.com || 2 | c@d.com || 3 | a@b.com |+----+---原创 2020-12-22 18:29:41 · 173 阅读 · 0 评论 -
LeetCode - Easy - 181. Employees Earning More Than Their Managers
TopicSQLDescriptionhttps://leetcode.com/problems/employees-earning-more-than-their-managers/The Employee table holds all employees including their managers. Every employee has an Id, and there is also a column for the manager Id.+----+-------+------原创 2020-12-22 17:31:07 · 135 阅读 · 0 评论 -
MySQL关键字EXPLAIN的用法及其案例
文章目录概述EXPLAIN输出的列的解释实例说明select_type的说明UNIONDEPENDENT UNION与DEPENDENT SUBQUERYSUBQUERYDERIVEDtype的说明system,consteq_refrefref_or_nullindex_mergeunique_subqueryindex_subqueryrangeindexALLextra的说明DistinctNot existsRange checked for each recordUsing filesortUsi原创 2020-06-17 21:03:40 · 458 阅读 · 0 评论 -
用Python连接MySQL并进行CRUD
Tag: MySQL, PyMySQL, Python准备条件Python 2.7MySQL 5.5安装 PyMySQL pip install PyMySQL放码过来创建一数据表CREATE TABLE `users` ( `id` int(11) NOT NULL AUTO_INCREMENT, `email` varchar(255) COLLATE utf...原创 2020-04-04 16:23:37 · 230 阅读 · 0 评论 -
MySQL备份与还原
概述在疫情期间,发生微盟删库事件,让企业损失惨重。由此可见,数据库备份的重要性可见一斑。当数据文件发生损坏、MySQL服务出现错误、系统内核崩溃、计算机硬件损坏或者数据被误删等事件时,使用一种有效的数据备份方案,尽量挽回损失。MySQL备份方案逻辑备份物理备份全备份增量备份…逻辑备份逻辑备份通过保存代表数据库结构及数据内容的描述信息实现,如,保存创建数据结构以及添加数据内容...原创 2020-03-14 00:17:06 · 254 阅读 · 1 评论 -
统计MySQL中某数据库硬盘占用量大小
放码过来select TABLE_NAME, concat(truncate(data_length/1024/1024,2),' MB') as data_size,concat(truncate(index_length/1024/1024,2),' MB') as index_sizefrom information_schema.tables where TABLE_SCHEM...原创 2020-03-12 22:30:09 · 707 阅读 · 0 评论