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. _______________________________________________ gdal-dev mailing list [email protected] http://lists.osgeo.org/mailman/listinfo/gdal-dev
