|
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; |