[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