[GRASSLIST:7260] Re: db.droptable
massimiliano.cannata at supsi.ch
Tue Jun 21 14:13:30 EDT 2005
I think that's because SELECT is for access the date while EXECUTE is
for manage the data.
So if you want to delete, update or insert some data db.execute is the
while for extract and query the data db.select is the right one.
David Finlayson wrote:
>I have been learning the GRASS SQL commands and don't fully understand
>why there are individual commands for some SQL statements and not
>others (for example why not just have db.execute?). In fact, I have
>found some SELECT statements don't work in db.execute but do work in
>db.select. This seems a bit confusing to me.
>On 6/21/05, Moritz Lennert <mlennert at club.worldonline.be> wrote:
>>On Tue, June 21, 2005 18:40, Aldo Clerici said:
>>>does it exist the db.droptable command?
>>>It is described in the GRASS GIS Reference Manual and in many tutorials, but
>>>it seems not to exist in my GRASS version (6.1.cvs).
>>Currently it does not exist. The recommended way of dropping a table is:
>>echo "DROP TABLE fmacopy" | db.execute
>>However, it wouldn't be too difficult to create a db.droptable if there is
Eng. Massimiliano Cannata
Scuola Universitaria Professionale della Svizzera Italiana
Istituto Scienze della Terra
Via Trevano, c.p. 72
Tel: +41 (0)58 666 62 18
Fax +41 (0)58 666 62 09
-------------- next part --------------
An HTML attachment was scrubbed...
More information about the grass-user