![](https://img-blog.csdnimg.cn/20201014180756922.png?x-oss-process=image/resize,m_fixed,h_64,w_64)
mysql
测试相关知识
newtag
切勿眼高手低
展开
-
leetcode-mysql 2021-06-04
来源:力扣(LeetCode)链接:https://leetcode-cn.com/problems/calculate-special-bonusTable: Employees+-------------+---------+| Column Name | Type |+-------------+---------+| employee_id | int || name | varchar || salary | int |...原创 2021-05-31 21:25:04 · 176 阅读 · 0 评论 -
leetcode-mysql 2021-06-03
Table: Employees+-------------+---------+| Column Name | Type |+-------------+---------+| employee_id | int || name | varchar || salary | int |+-------------+---------+employee_id is the primary key for this table.Each row ...原创 2021-05-31 20:57:16 · 162 阅读 · 0 评论 -
leetcode-mysql 2021-06-02
leetcode-mysql 2021-06-02原创 2021-05-30 21:39:11 · 187 阅读 · 0 评论 -
leetcode-mysql 2021-06-01
leetcode-mysql 2021-06-01原创 2021-05-30 20:47:11 · 145 阅读 · 0 评论 -
leetcode-mysql 2021-05-31
有一个courses 表 ,有: student(学生) 和 class (课程)。请列出所有超过或等于5名学生的课。例如,表:+---------+------------+| student | class |+---------+------------+| A | Math || B | English || C | Math || D | Biology || E ...原创 2021-05-30 20:18:47 · 87 阅读 · 0 评论 -
leetcode-mysql 2021-05-30
占位原创 2021-05-30 20:05:47 · 54 阅读 · 0 评论 -
leetcode-mysql 2021-05-28
leetcode-mysql 2021-05-28原创 2021-05-28 19:10:53 · 97 阅读 · 0 评论 -
leetcode-mysql 2021-05-27
Product 表:+-------------+---------+| Column Name | Type |+-------------+---------+| product_id | int || name | varchar |+-------------+---------+product_id 是这张表的主键表中含有产品 id 、产品名称。产品名称都是小写的英文字母,产品名称都是唯一的Invoice 表:+-------------...原创 2021-05-26 19:08:49 · 116 阅读 · 0 评论 -
leetcode-mysql 2021-05-26
来源:力扣(LeetCode)链接:https://leetcode-cn.com/problems/project-employees-ii 【侵删】ExampleA(项目员工II)Table:Project+-------------+---------+| Column Name | Type |+-------------+---------+| project_id | int || employee_id | int |+-------...原创 2021-05-25 08:52:19 · 134 阅读 · 0 评论 -
leetcode-mysql 2021-05-25
来源:力扣(LeetCode)链接:https://leetcode-cn.com/problems/students-and-examinations 【侵删】ExampleA(学生们参加各科测试的次数)学生表: Students+---------------+---------+| Column Name | Type |+---------------+---------+| student_id | int || student_name | v...原创 2021-05-24 20:13:08 · 227 阅读 · 0 评论 -
leetcode-mysql 2021-05-24
来源:力扣(LeetCode)链接:https://leetcode-cn.com/problems/user-activity-for-the-past-30-days-i 【侵删】ExampleA (查询近30天活跃用户数)活动记录表:Activity+---------------+---------+| Column Name | Type |+---------------+---------+| user_id | int || se...原创 2021-05-23 22:25:56 · 157 阅读 · 0 评论 -
leetcode-mysql 2021-05-23
leetcode-mysql 2021-05-23原创 2021-05-23 22:08:18 · 94 阅读 · 0 评论 -
leetcode-mysql 2021-05-22
leetcode-mysql 2021-05-22原创 2021-05-23 21:32:57 · 99 阅读 · 1 评论 -
leetcode-mysql 2021-05-21
leetcode-mysql 2021-05-21原创 2021-05-23 21:18:11 · 112 阅读 · 0 评论 -
leetcode-mysql 2021-05-20
leetcode-mysql 2021-05-19原创 2021-05-23 20:58:32 · 69 阅读 · 0 评论 -
leetcode-mysql 2021-05-19
leetcode-mysql 2021-05-19原创 2021-05-23 20:40:12 · 122 阅读 · 0 评论 -
leetcode-mysql 2021-05-18
leetcode-mysql 2021-05-18 占位原创 2021-05-23 11:36:15 · 80 阅读 · 0 评论 -
leetcode-mysql 2021-05-17
来源:力扣(LeetCode)链接:https://leetcode-cn.com/problems/friendly-movies-streamed-last-month 【侵删】ExampleA (上月播放的儿童适宜电影)表: TVProgram+---------------+---------+| Column Name | Type |+---------------+---------+| program_date | date || content_...原创 2021-05-16 21:56:19 · 122 阅读 · 0 评论 -
leetcode-mysql 2021-05-16
leetcode-mysql 2021-05-16原创 2021-05-16 21:29:11 · 59 阅读 · 0 评论 -
leetcode-mysql 2021-05-15
leetcode-mysql 2021-05-15原创 2021-05-16 21:16:07 · 95 阅读 · 0 评论 -
leetcode-mysql 2021-05-14
leetcode-mysql 2021-05-14原创 2021-05-16 20:31:43 · 49 阅读 · 0 评论 -
leetcode-mysql 2021-05-13
leetcode-mysql 2021-05-13原创 2021-05-16 14:52:32 · 98 阅读 · 0 评论 -
leetcode-mysql 2021-05-12
leetcode-mysql 2021-05-12原创 2021-05-16 14:40:15 · 85 阅读 · 0 评论 -
leetcode-mysql 2021-05-11
leetcode-mysql 2021-05-11原创 2021-05-16 14:06:52 · 66 阅读 · 0 评论 -
leetcode-mysql 2021-05-10
leetcode-mysql 2021-05-10原创 2021-05-16 13:49:34 · 131 阅读 · 1 评论 -
leetcode-mysql 2021-05-09
leetcode-mysql 2021-05-08临时占位原创 2021-05-13 18:32:44 · 92 阅读 · 0 评论 -
leetcode-mysql 2021-05-08
来源:Leetcode 地址: https://leetcode-cn.com/problems/percentage-of-users-attended-a-contest/【侵删】ExampleA (各赛事的用户注册率)用户表:Users+-------------+---------+| Column Name | Type |+-------------+---------+| user_id | int || user_name | var...原创 2021-05-08 21:17:20 · 197 阅读 · 0 评论 -
leetcode-mysql 2021-05-07
来源:Leetcode 地址:https://leetcode-cn.com/problems/ad-free-sessions/ 【侵删】ExampleA: (Ad-Free Sessions)Table: Playback+-------------+------+| Column Name | Type |+-------------+------+| session_id | int || customer_id | int || start_time | i...原创 2021-05-06 21:21:03 · 147 阅读 · 0 评论 -
leetcode-mysql 2021-05-06 【临时知识】(关于where group by 以及 having)
Reference:QiaoZhi&江枫渔火L1、where 后不能跟聚合函数,因为where执行顺序大于聚合函数。2、where 子句的作用是在对查询结果进行分组前,将不符合where条件的行去掉,即在分组之前过滤数据,条件中不能包含聚组函数,使用where条件显示特定的行。3、having 子句的作用是筛选满足条件的组,即在分组之后过滤数据,条件中经常包含聚组函数,使用having 条件显示特定的组,也可以使用多个分组标准进行分组。基本使用顺序:where group ...原创 2021-05-06 18:40:31 · 67 阅读 · 0 评论 -
leetcode-mysql 2021-05-06
来源:Leetcode 地址:https://leetcode-cn.com/problems/customer-order-frequency/ 【侵删】ExampleA(消费者下单频率)表: Customers+---------------+---------+| Column Name | Type |+---------------+---------+| customer_id | int || name | varchar...原创 2021-05-06 18:24:37 · 78 阅读 · 0 评论 -
leetcode-mysql 2021-05-05
来源:Leetcode 地址:https://leetcode-cn.com/problems/list-the-products-ordered-in-a-period/ 【侵删】ExampleA(列出指定时间段内所有的下单产品)表: Products+------------------+---------+| Column Name | Type |+------------------+---------+| product_id |...原创 2021-05-05 21:11:59 · 72 阅读 · 0 评论 -
leetcode-mysql 2021-05-04
来源:力扣(LeetCode)链接:https://leetcode-cn.com/problems/employee-bonus/【侵删】ExampleA(员工奖金):选出所有 bonus < 1000 的员工的 name 及其 bonus。Employee 表单+-------+--------+-----------+--------+| empId | name | supervisor| salary |+-------+--------+-----------+...原创 2021-05-04 18:06:25 · 117 阅读 · 0 评论 -
leetcode-mysql 2021-05-03
来源:力扣(LeetCode)链接:https://leetcode-cn.com/problems/unique-orders-and-customers-per-month/【侵删】ExampleA:(按月统计订单数与顾客数)表:Orders+---------------+---------+| Column Name | Type |+---------------+---------+| order_id | int || order_da...原创 2021-05-03 09:43:55 · 115 阅读 · 0 评论 -
leetcode-mysql 2021-05-02
来源:力扣(LeetCode)链接:https://leetcode-cn.com/problems/weather-type-in-each-country/comments/【侵删】ExampleA:(不同国家的天气类型)国家表:Countries+---------------+---------+| Column Name | Type |+---------------+---------+| country_id | int || countr...原创 2021-05-03 09:23:45 · 97 阅读 · 0 评论 -
leetcode-mysql 2021-05-01
来源: 【侵删】哈哈哈哈,今天来女朋友家(大内蒙),开心~~~原创 2021-05-01 23:18:00 · 158 阅读 · 0 评论 -
leetcode-mysql 2021-04-30
来源:https://leetcode-cn.com/problems/find-users-with-valid-e-mails/ &https://leetcode-cn.com/problems/game-play-analysis-i/again (shame on me)最近两天的事情有点多,暂时经常练习了但是没有将对应的内容搬到这里来;ExampleA:(查找拥有有效邮箱的用户)用户表:Users+---------------+---------+| C...原创 2021-05-01 21:25:43 · 141 阅读 · 0 评论 -
leetcode-mysql 2021-04-29
罪恶:(自己懈怠了一天多的时间shame on me)来源:https://leetcode-cn.com/problems/combine-two-tables/ 【侵删】ExampleA: (表组合)表1: Person+-------------+---------+| 列名 | 类型 |+-------------+---------+| PersonId | int || FirstName | varchar || Last...原创 2021-04-30 21:01:27 · 135 阅读 · 1 评论 -
leetcode-mysql 2021-04-28
来源:https://leetcode-cn.com/problems/immediate-food-delivery-i/ 【侵删】ExampleA:即时食物配送 I配送表: Delivery+-----------------------------+---------+| Column Name | Type |+-----------------------------+---------+| delivery_id ...原创 2021-04-28 16:09:02 · 90 阅读 · 0 评论 -
leetcode-mysql 2021-04-27
来源:https://leetcode-cn.com/problems/find-total-time-spent-by-each-employee 【侵删修改】ExampleA:表: Employees+-------------+------+| Column Name | Type |+-------------+------+| emp_id | int || event_day | date || in_time | int || out_tim...原创 2021-04-27 08:29:35 · 142 阅读 · 0 评论 -
leetcode-mysql 2021-04-26
来源:https://leetcode-cn.com/problems/shortest-distance-in-a-line/【侵删修改】ExampleA:【直线上的最近距离】表point保存了一些点在 x 轴上的坐标,这些坐标都是整数。写一个查询语句,找到这些点中最近两个点之间的距离。| x ||-----|| -1 || 0 || 2 |最近距离显然是 '1' ,是点 '-1' 和 '0' 之间的距离。所以输出应该如下:| shortest||-..原创 2021-04-25 21:59:06 · 85 阅读 · 0 评论