cs122a-2016-spring: 2016s-cs122a-hw5-template.2.txt

File 2016s-cs122a-hw5-template.2.txt, 874 bytes (added by alsaudi.ad, 5 years ago)

HW5-templete

Line 
1-- This file demonstrates an example that how your file should look like.
2-- The file name should be HW5_groupID.txt (e.g., HW5_01.txt).
3-- Please put your group information here.
4-- GroupID: XX
5-- SID1: XXXXX, NAME: YYYYYY
6-- SID2: WWW, NAME: ZZZZZZ
7-- SID3: MMMMM, NAME: NNNNNN
8--
9-- Delete the following example queries and paste your results in the below.
10-- Do not modify anything after copying the results from MySQLWorkBench into the file.
11--
12Execute:
13> SELECT cid FROM Customer LIMIT 1 /* Q1 */
14
15+ -------- +
16| cid      |
17+ -------- +
18| 1        |
19| NULL     |
20+ -------- +
212 rows
22
23Execute:
24> SELECT "Q2: skipped"
25
26+ ---------------- +
27| Q2: skipped      |
28+ ---------------- +
29| Q2: skipped      |
30+ ---------------- +
311 rows
32
33Execute:
34> SELECT lid FROM Lounge LIMIT 1 /* Q3 */
35
36+ -------- +
37| lid      |
38+ -------- +
39| 1        |
40| NULL     |
41+ -------- +
422 rows