7.out

《嵌入式Linux应用开发详解》中的源代码

Welcome to the miniSQL monitor.  Type \h for help.


mSQL >     -> 
Query buffer
------------
select staff.first_name, staff.last_name, users.uname from staff, users 
	where staff.staff_id = users.staff_id 
[continue]
    -> 
Query OK.  5 row(s) modified or retrieved.

 +------------+------------+-----------------+
 | first_name | last_name  | uname           |
 +------------+------------+-----------------+
 | David      | Hughes     | bambi           |
 | Fred       | Smith      | fred            |
 | Bill       | Jones      | bill            |
 | Mike       | Horn       | mike            |
 | Tom        | Hanks      | tom             |
 +------------+------------+-----------------+



mSQL >     ->     ->     ->     -> 
Query buffer
------------
select S.first_name, S.last_name, U.uname 
	from staff=S, users=U
	where S.staff_id = U.staff_id 
[continue]
    -> 
Query OK.  5 row(s) modified or retrieved.

 +------------+------------+-----------------+
 | first_name | last_name  | uname           |
 +------------+------------+-----------------+
 | David      | Hughes     | bambi           |
 | Fred       | Smith      | fred            |
 | Bill       | Jones      | bill            |
 | Mike       | Horn       | mike            |
 | Tom        | Hanks      | tom             |
 +------------+------------+-----------------+



mSQL >     ->     ->     ->     ->     -> 
Query buffer
------------
select staff.first_name, staff.last_name, users.uname, contact.phone
	from staff, users, contact
	where staff.staff_id = users.staff_id 
		and users.staff_id = contact.staff_id
[continue]
    -> 
Query OK.  5 row(s) modified or retrieved.

 +------------+------------+-----------------+-----------------+
 | first_name | last_name  | uname           | phone           |
 +------------+------------+-----------------+-----------------+
 | Fred       | Smith      | fred            | [phone]  |
 | Tom        | Hanks      | tom             | [phone]  |
 | Mike       | Horn       | mike            | [phone]  |
 | Bill       | Jones      | bill            | [phone]  |
 | David      | Hughes     | bambi           | [phone]  |
 +------------+------------+-----------------+-----------------+



mSQL >     ->     ->     ->     -> 
Query buffer
------------
select S.first_name, S.last_name, U.uname, C.phone
	from staff = S, users = U, contact = C
	where S.staff_id = U.staff_id and U.staff_id = C.staff_id
[continue]
    -> 
Query OK.  5 row(s) modified or retrieved.

 +------------+------------+-----------------+-----------------+
 | first_name | last_name  | uname           | phone           |
 +------------+------------+-----------------+-----------------+
 | Fred       | Smith      | fred            | [phone]  |
 | Tom        | Hanks      | tom             | [phone]  |
 | Mike       | Horn       | mike            | [phone]  |
 | Bill       | Jones      | bill            | [phone]  |
 | David      | Hughes     | bambi           | [phone]  |
 +------------+------------+-----------------+-----------------+



mSQL >     ->     ->     ->     ->     -> 
Query buffer
------------
select S._rowid, S.first_name, S.last_name, U.uname, C.phone
	from staff = S, users = U, contact = C
	where S.staff_id = U.staff_id and U.staff_id = C.staff_id
[continue]
    -> 
Query OK.  5 row(s) modified or retrieved.

 +----------+------------+------------+-----------------+-----------------+
 | _rowid   | first_name | last_name  | uname           | phone           |
 +----------+------------+------------+-----------------+-----------------+
 | 1        | Fred       | Smith      | fred            | [phone]  |
 | 4        | Tom        | Hanks      | tom             | [phone]  |
 | 3        | Mike       | Horn       | mike            | [phone]  |
 | 2        | Bill       | Jones      | bill            | [phone]  |
 | 0        | David      | Hughes     | bambi           | [phone]  |
 +----------+------------+------------+-----------------+-----------------+



mSQL >     ->     ->     ->     -> 
Query buffer
------------
select S.first_name, S.last_name, U.uname, P.pay_date, P.pay_amount
	from staff = S, users = U, pay = P
	where S.staff_id = U.staff_id and U.staff_id = P.staff_id
	order by S.last_name
[continue]
    -> 
Query OK.  10 row(s) modified or retrieved.

 +------------+------------+-----------------+-------------+------------+
 | first_name | last_name  | uname           | pay_date    | pay_amount |
 +------------+------------+-----------------+-------------+------------+
 | David      | Hughes     | bambi           | 01-Jan-1997 | 1000.00    |
 | David      | Hughes     | bambi           | 01-Mar-1997 | 1000.00    |
 | David      | Hughes     | bambi           | 01-Feb-1997 | 1000.00    |
 | Bill       | Jones      | bill            | 16-Oct-1991 | 25.00      |
 | Bill       | Jones      | bill            | 19-Jun-1996 | 3.00       |
 | Bill       | Jones      | bill            | 01-Mar-1997 | 750.00     |
 | Bill       | Jones      | bill            | 27-Dec-1992 | 15.00      |
 | Fred       | Smith      | fred            | 15-Jan-1997 | 750.00     |
 | Fred       | Smith      | fred            | 15-Mar-1997 | 750.00     |
 | Fred       | Smith      | fred            | 15-Feb-1997 | 750.00     |
 +------------+------------+-----------------+-------------+------------+



mSQL >     ->     ->     ->     ->     -> 
Query buffer
------------
select distinct S.first_name, S.last_name, U.uname, P.pay_amount
	from staff = S, users = U, pay = P
	where S.staff_id = U.staff_id and U.staff_id = P.staff_id
	order by S.last_name
[continue]
    -> 
Query OK.  6 row(s) modified or retrieved.

 +------------+------------+-----------------+------------+
 | first_name | last_name  | uname           | pay_amount |
 +------------+------------+-----------------+------------+
 | David      | Hughes     | bambi           | 1000.00    |
 | Bill       | Jones      | bill            | 25.00      |
 | Bill       | Jones      | bill            | 3.00       |
 | Bill       | Jones      | bill            | 750.00     |
 | Bill       | Jones      | bill            | 15.00      |
 | Fred       | Smith      | fred            | 750.00     |
 +------------+------------+-----------------+------------+



mSQL > 
Bye!