[gdal-dev] ogrinfo sql UPDATE
Even Rouault
even.rouault at mines-paris.org
Wed Sep 5 14:31:43 PDT 2012
> ogrinfo wyoming.shp -sql 'UPDATE wyoming SET area=1000 WHERE area is
> NULL' ERROR 1: SQL Expression Parsing Error: syntax error
>
> Is sql update supported or i miss something?
UPDATE is not supported indeed.
The subset of SQL understood by OGR is documented at :
http://gdal.org/ogr/ogr_sql.html
Note: if you use latest GDAL trunk, you will be able to use UPDATE statements
by using the SQLite SQL dialect. See http://gdal.org/ogr/ogr_sql_sqlite.html
>
> Thanks
> Giuseppe
More information about the gdal-dev
mailing list