MySql
文章平均质量分 62
angelof7
这个作者很懒,什么都没留下…
展开
-
Mac下MySQL卸载方法
sudo rm /usr/local/mysqlsudo rm -rf /usr/local/mysql*sudo rm -rf /Library/StartupItems/MySQLCOMsudo rm -rf /Library/PreferencePanes/My*vim /etc/hostconfig (and removed the line MYSQLCOM=-YES-)rm转载 2014-07-15 15:34:04 · 469 阅读 · 0 评论 -
[LeetCode] Consecutive Numbers - SQL
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 || 6 | 2原创 2015-03-10 20:38:50 · 1200 阅读 · 0 评论 -
[LeetCode] Rank Scores - SQL
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 integer value.原创 2015-03-10 21:18:19 · 939 阅读 · 0 评论 -
[LeetCode] Department Highest & Top 3 Salary - SQL
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 | Department原创 2015-03-10 21:56:35 · 762 阅读 · 0 评论