数据库学习
liuchenjane
这个作者很懒,什么都没留下…
展开
-
Ubuntu 安装 mysql
转载出处:点击打开链接1. sudo apt-get update 装前更新2. sudo apt-get install mysql-server3. sudo apt-get install mysql-client4. sudo apt-get install libmysqlclient-dev验证是否成功:sudo netstat -tap | grep mys转载 2017-03-02 10:02:07 · 240 阅读 · 0 评论 -
175. Combine Two Tables
Table: Person+-------------+---------+| Column Name | Type |+-------------+---------+| PersonId | int || FirstName | varchar || LastName | varchar |+-------------+---------+Per转载 2017-03-04 14:16:02 · 539 阅读 · 0 评论 -
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.+----+-------+| Id | Na原创 2017-03-04 16:35:42 · 343 阅读 · 0 评论 -
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 | Salary |原创 2017-03-06 10:53:11 · 452 阅读 · 0 评论