[GRASSLIST:7260] Re: db.droptable

[Massimiliano Cannata]

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 
right command,
while for extract and query the data db.select is the right one.

Cheers,
Maxi


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.
>
>David
>
>On 6/21/05, Moritz Lennert <mlennert at club.worldonline.be> wrote:
>  
>
>>On Tue, June 21, 2005 18:40, Aldo Clerici said:
>>    
>>
>>>Dear GRASSusers,
>>>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
>>real demand.
>>
>>Moritz
>>
>>
>>    
>>
>
>
>  
>

-- 

Eng. Massimiliano Cannata
Scuola Universitaria Professionale della Svizzera Italiana
Istituto Scienze della Terra
Via Trevano, c.p. 72
CH-6952 Canobbio-Lugano
Tel: +41 (0)58 666 62 18
Fax +41 (0)58 666 62 09

-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://lists.osgeo.org/pipermail/grass-user/attachments/20050621/03feef2c/attachment.html