|
6 | 6 | --
|
7 | 7 | -- Copyright (c) 1994, Andrew Yu, University of California
|
8 | 8 | --
|
9 |
| --- $Id: basics.source,v 1.2 1997/06/25 19:59:57 momjian Exp $ |
| 9 | +-- $Id: basics.source,v 1.3 1999/07/08 15:27:01 momjian Exp $ |
10 | 10 | --
|
11 | 11 | ---------------------------------------------------------------------------
|
12 | 12 |
|
@@ -94,12 +94,12 @@ ORDER BY city;
|
94 | 94 | --another class.
|
95 | 95 | -----------------------------
|
96 | 96 |
|
97 |
| -SELECT * INTO TABLEtemp |
| 97 | +SELECT * INTO TABLEmytemp |
98 | 98 | FROM weather
|
99 | 99 | WHERE city = 'San Francisco'
|
100 | 100 | and prcp > 0.0;
|
101 | 101 |
|
102 |
| -SELECT * fromtemp; |
| 102 | +SELECT * frommytemp; |
103 | 103 |
|
104 | 104 | -----------------------------
|
105 | 105 | -- Aggregates
|
@@ -185,4 +185,4 @@ SELECT * from weather;
|
185 | 185 | -- can no longer use those tables.
|
186 | 186 | -----------------------------
|
187 | 187 |
|
188 |
| -DROP TABLE weather, cities,temp; |
| 188 | +DROP TABLE weather, cities,mytemp; |