数据库
文章平均质量分 88
da_kao_la
这个作者很懒,什么都没留下…
展开
-
Java数据库编程
应数据库课程作业要求,用Java编写了一个简单的图形界面化数据库查询程序,实际用于数据库编程的时间并不多,大部分时间都在做界面开发了。下面就分享一下开发经历和其中的一些坑。环境配置1. 数据库服务器操作系统: Windows10(把自己的笔记本当做数据库服务器,然后用数据库客户端连接localhost)2. 数据库服务器: MySQL 8...原创 2018-12-15 00:10:15 · 623 阅读 · 0 评论 -
Mysql命令行结果竖排显示
在Mysql的命令行查询中,当字段较多或者一个字段的值较长以至于一行排布不下时,可以用\G替代原查询命令结尾的分号使得查询的一条记录从原来的横排显示变为竖排显示。例如:SELECT * FROM test.users LIMIT 2;改为SELECT * FROM test.users LIMIT 2\G...原创 2019-07-19 14:45:52 · 6144 阅读 · 0 评论 -
LeetCode 180. Consecutive Numbers (sql)
180.Consecutive NumbersMediumSQL SchemaWrite a SQL query to find all numbers that appear at least three times consecutively.+----+-----+| Id | Num |+----+-----+| 1 | 1 || 2 | 1 ||...原创 2019-08-17 17:19:44 · 224 阅读 · 0 评论 -
LeetCode 181. Employees Earning More Than Their Managers (sql)
181.Employees Earning More Than Their ManagersEasySQL SchemaTheEmployeetable holds all employees including their managers. Every employee has an Id, and there is also a column for the manager...原创 2019-08-17 17:25:47 · 224 阅读 · 0 评论 -
LeetCode 182. Duplicate Emails (sql)
182.Duplicate EmailsEasySQL SchemaWrite a SQL query to find all duplicate emails in a table namedPerson.+----+---------+| Id | Email |+----+---------+| 1 | a@b.com || 2 | c@d.com |...原创 2019-08-17 17:28:39 · 122 阅读 · 0 评论 -
LeetCode 183. Customers Who Never Order (sql)
183.Customers Who Never OrderEasySQL SchemaSuppose that a website contains two tables, theCustomerstable and theOrderstable. Write a SQL query to find all customers who never order anything...原创 2019-08-17 17:33:01 · 116 阅读 · 0 评论 -
LeetCode 185. Department Top Three Salaries (sql)
185.Department Top Three SalariesHardSQL SchemaTheEmployeetable holds all employees. Every employee has an Id, and there is also a column for the department Id.+----+-------+--------+-----...原创 2019-08-17 17:56:03 · 154 阅读 · 0 评论 -
LeetCode 196. Delete Duplicate Emails (sql)
196.Delete Duplicate EmailsEasyWrite a SQL query todeleteall duplicate email entries in a table namedPerson, keeping only unique emails based on itssmallestId.+----+------------------+| ...原创 2019-08-17 18:20:00 · 177 阅读 · 0 评论