mysql
酱油何在
渣硕一枚
展开
-
【mysql学习笔记】-检索数据基本用法
1.简单检索1)检索单个列:select 列名 from 表名; 如: select prod_name from products;2)检索多个列:列名之间用逗号(,)隔开,如:select prod_name,prod_price from products;3)检索所有列:用星号(*)通配符来表示,如:select * from products;4)检索不同的行:用dist原创 2015-09-18 12:14:37 · 4446 阅读 · 0 评论 -
【leetcode Database】178. Rank Scores
题目:Write a SQL query to rank scores. If there is a tie between two scores, both should have the same ranking. Note that after a tie, the next ranking number should be the next consecutive intege原创 2016-08-08 17:06:10 · 4297 阅读 · 0 评论 -
【leetcode Database】180. Consecutive Numbers
题目:Write a SQL query to find all numbers that appear at least three times consecutively.+----+-----+| Id | Num |+----+-----+| 1 | 1 || 2 | 1 || 3 | 1 || 4 | 2 || 5 | 1 |原创 2016-08-08 15:51:12 · 3803 阅读 · 0 评论 -
【leetcode Database】185. Department Top Three Salaries
题目:The Employee table holds all employees. Every employee has an Id, and there is also a column for the department Id.+----+-------+--------+--------------+| Id | Name | Salary | Departmen原创 2016-08-08 14:25:14 · 3710 阅读 · 0 评论 -
【leetcode Database】177. Nth Highest Salary
题目:Write a SQL query to get the nth highest salary from the Employee table.+----+--------+| Id | Salary |+----+--------+| 1 | 100 || 2 | 200 || 3 | 300 |+----+--------+F原创 2016-08-04 18:17:17 · 4462 阅读 · 0 评论 -
【leetcode Database】196. 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 |+-原创 2016-08-04 13:36:50 · 3409 阅读 · 0 评论 -
【leetcode Database】184. Department Highest Salary
题目:The Employee table holds all employees. Every employee has an Id, a salary, and there is also a column for the department Id.+----+-------+--------+--------------+| Id | Name | Salary |原创 2016-08-03 18:47:07 · 4210 阅读 · 0 评论 -
【mysql学习笔记】-事务处理
1.基本概念1)事务:指一组SQL语句,是在一次逻辑中对数据库执行的一系列操作2)回退:指撤销指定SQL语句的过程3)提交:指将未存储的SQL语句结果写入数据库表4)保留点:指事务处理中设置的临时占位符,可以对它发布回退5)事务处理:事务处理可以用来维护数据库的完整性,它保证成批的mysql操作要么完全执行,要么完全不执行2.事务的性质1)原子性:事务中定义的一系列操作原创 2016-06-21 14:04:26 · 4333 阅读 · 0 评论 -
【leetcode Database】176. Second Highest Salary
题目:Write a SQL query to get the second highest salary from the Employee table.+----+--------+| Id | Salary |+----+--------+| 1 | 100 || 2 | 200 || 3 | 300 |+----+--------+原创 2016-07-27 15:26:48 · 4206 阅读 · 0 评论 -
【leetcode Database】197. Rising Temperature
题目:Given a Weather table, write a SQL query to find all dates' Ids with higher temperature compared to its previous (yesterday's) dates.+---------+------------+------------------+| Id(INT)原创 2016-07-27 14:47:50 · 3685 阅读 · 0 评论 -
【leetcode Database】183. Customers Who Never Order
题目:Suppose that a website contains two tables, the Customers table and the Orders table. Write a SQL query to find all customers who never order anything.Table: Customers.+----+-------+原创 2016-07-27 14:04:22 · 3485 阅读 · 0 评论 -
【leetcode Database】181. 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.+----+-------+--------+-----------+| Id | Name |原创 2016-07-27 11:30:18 · 4221 阅读 · 0 评论 -
【leetcode Database】182. 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 |+----+---------+原创 2016-07-27 10:52:28 · 3654 阅读 · 0 评论 -
【leetcode Database】175.Combine Two Tables
题目:Table: Person+-------------+---------+| Column Name | Type |+-------------+---------+| PersonId | int || FirstName | varchar || LastName | varchar |+-------------+-----原创 2016-07-26 17:53:52 · 3654 阅读 · 0 评论 -
【mysql学习笔记】-explain的用法
1.explain的使用方法mysql中的explain命令显示了mysql如何使用索引来处理select语句以及连接表。使用时直接在select语句前加上explain就行了。例子如下:explain select * from orders;运行结果如下:创建索引后的运行结果如下:2.explain每列的解释1)id:select识别符,这是原创 2016-07-12 16:56:23 · 3153 阅读 · 0 评论 -
【mysql学习笔记】-索引
1.基本概念1)索引的概念:是对数据库表中一列或多列的值进行排序的一种结构,使用索引可快速访问数据表中的特定信息。2)索引的优点:提高查询,联合查询,分级和排序的时间;缺点:索引占空间,维护索引时需要耗费时间。2.索引的底层实现索引的底层有两种实现方式,一种是B树,另一种是哈希表。1)B-Tree:B树是为磁盘或者其他直接存取的辅助存储设备而设计的一种平衡搜索树,B树类似于红黑原创 2016-07-12 16:50:54 · 3575 阅读 · 0 评论 -
【leetcode Database】262. Trips and Users
题目:The Trips table holds all taxi trips. Each trip has a unique Id, while Client_Id and Driver_Id are both foreign keys to the Users_Id at theUsers table. Status is an ENUM type of (‘completed原创 2016-08-09 11:22:00 · 4325 阅读 · 0 评论