1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
|
<h2>DESCRIPTION</h2>
<em>db.execute</em> allows the user to execute SQL statements.
<h2>NOTE</h2>
If parameters for database connection are already set with
<a HREF="db.connect.html">db.connect</a>, they are taken as default values and
do not need to be spcified each time.
<h2>EXAMPLES</h2>
<em>Create a new table with columns 'cat' and 'soiltype':</em><br>
<tt>echo 'create table soils (cat integer, soiltype varchar(10) )' | <b>db.execute</b></tt>
<p>
<em>Create a new table using a file with SQL statements:</em><br>
<b>db.execute driver</b><em>=odbc</em> <b>database=</b><em>g51test</em>
<b>input=</b><em>file.sql</em>
<P>
<em>Update attribute entries to new value based on SQL rule:</em><br>
<tt>echo "UPDATE roads SET travelcost=5 WHERE cat=1" | <b>db.execute</b></tt>
<P>
<em>Update attribute entries to new value based on SQL rule:</em><br>
<tt>echo "UPDATE dourokukan SET testc=50 WHERE testc is NULL" | <b>db.execute</b></tt>
<P>
<em>Add new column to attribute table:</em><br>
<tt>echo "ALTER TABLE roads ADD COLUMN length double" | <b>db.execute</b></tt>
<P>
<em>Drop table (not supported by all drivers)</em><br>
<tt>echo "DROP TABLE fmacopy" | <b>db.execute</b></tt>
<p>
<em>Update attribute with multiple SQL instructions in file (e.g., file.sql,
instruction line must end with semicolon):</em><br>
<tt>UPDATE roads SET travelcost=5 WHERE cat=1;</tt><br>
<tt>UPDATE roads SET travelcost=2 WHERE cat=2;</tt><br>
<br>
<tt>cat file.sql | <b>db.execute</b></tt>
<h2>SEE ALSO</h2>
<em><a HREF="db.columns.html">db.columns</a>,
<a HREF="db.describe.html">db.describe</a>,
<a HREF="db.drivers.html">db.drivers</a>,
<a HREF="db.droptable.html">db.droptable</a>,
<a HREF="db.login.html">db.login</a>,
<a HREF="db.select.html">db.select</a>,
<a HREF="db.tables.html">db.tables</a>,
<a HREF="sql.html">GRASS SQL interface</a></em>
<h2>AUTHOR</h2>
CERL
<p><i>Last changed: $Date: 2005/05/06 13:31:29 $</i>
|
