[gdal-dev] How to add more than one column to a shapefile using ogrinfo

[aborruso]

Hi Jukka,


Rahkonen Jukka (MML) wrote
> Do you know some database that accepts SQL "ALTER TABLE foo ADD COLUMN
> bar1, bar2"? At least SQLite and PostgreSQL don't. That kind of usage is
> not mentioned in a bunch of documents about SQL language which I browsed
> through, for example http://www.w3schools.com/sql/sql_alter.asp.

it's certainly a PostgreSQL syntax, and my (wrong) question derives from it.
And it's just like you wrote:
ALTER TABLE public.table ADD COLUMN col1 int, ADD COLUMN col2 int;

And in MySQL should be something like:
ALTER TABLE table
ADD COLUMN colA VARCHAR(10) NOT NULL,
ADD COLUMN colB INT(10) UNSIGNED NOT NULL,
AFTER thiscolumn

I think it works also in Microsoft SQL server and Oracle.

Best regards,

Andrea





--
View this message in context: http://osgeo-org.1560.x6.nabble.com/How-to-add-more-than-one-column-to-a-shapefile-using-ogrinfo-tp5263730p5263821.html
Sent from the GDAL - Dev mailing list archive at Nabble.com.