DESCRIPTION
db.execute allows the user to execute SQL statements.
NOTE
If parameters for database connection are already set with
db.connect, they are taken as default values and
do not need to be spcified each time.
EXAMPLES
Create a new table with columns 'cat' and 'soiltype':
echo 'create table soils ("cat" int, "soiltype" text)' | db.execute
or
cat file.sql | db.execute
Create a new table using a file with SQL statements:
db.execute driver=odbc database=g51test
input=file.sql
Update attribute entries to new value based on SQL rule:
echo "UPDATE roads SET travelcost=5 WHERE cat=1" | db.execute
Update attribute entries to new value based on SQL rule:
echo "UPDATE dourokukan SET testc=50 WHERE testc is NULL" | db.execute
Add new column to attribute table:
echo "ALTER TABLE roads ADD COLUMN length double" | db.execute
SEE ALSO
GRASS 5.7 tutorial pages,
db.columns,
db.describe,
db.drivers,
db.droptable,
db.login,
db.select,
db.tables,
GRASS SQL interface
AUTHOR
CERL
Last changed: $Date$