SQL - Revision history

Neteler: +SpatiaLite

2017-02-02T10:11:51Z

← Older revision		Revision as of 10:11, 2 February 2017
Line 7:		Line 7:
	* Using [[Openoffice.org with SQL Databases]]		* Using [[Openoffice.org with SQL Databases]]
	* [[SQL rename columns]]		* [[SQL rename columns]]
			* [[SpatiaLite]]

	=== Analysing SQL syntax errors/table import or copy problems ===		=== Analysing SQL syntax errors/table import or copy problems ===

2017-01-13T18:15:30Z

example for YMD from DOY.

← Older revision		Revision as of 18:15, 13 January 2017
Line 27:		Line 27:
	alter table TABLE add column NEW_COLUMN text;		alter table TABLE add column NEW_COLUMN text;
	update TABLE set NEW_COLUMN=substr('000000'\|\|OLD_COLUMN, length('000000'\|\|OLD_COLUMN)-5, 6);		update TABLE set NEW_COLUMN=substr('000000'\|\|OLD_COLUMN, length('000000'\|\|OLD_COLUMN)-5, 6);

			=== Examples ===

			==== Combining columns for date calculations ====

			An example command that builds a YMD string from a column that contains the Day of Year (DOY) is:

			db.execute sql="UPDATE <DB> SET YMD=date('2015-01-01', +CAST(DOY AS text) \|\| ' days');"


	[[Category:FAQ]]		[[Category:FAQ]]

2016-04-15T13:06:39Z

← Older revision		Revision as of 13:06, 15 April 2016
Line 1:		Line 1:
	== SQL support in GRASS GIS ==		== SQL support in GRASS GIS ==

	GRASS 6 uses SQL for vector attribute management.		GRASS GIS uses SQL for vector attribute management.

	* {{cmd\|sql}} Overview of SQL in GRASS		* {{cmd\|sql}} Overview of SQL in GRASS

2012-03-29T13:38:18Z

fixing english

← Older revision		Revision as of 13:38, 29 March 2012
Line 24:		Line 24:
	=== Formatting ===		=== Formatting ===

	If your data should have values as character with zero but ~~you have number leading zero~~ (~~in the example it should be six number~~) ~~in SQLite~~ you can run		If your data should have values as character with leading zero (000123) but they are lacking (123) then you can run
	alter table TABLE add column NEW_COLUMN text;		alter table TABLE add column NEW_COLUMN text;
	update TABLE set NEW_COLUMN=substr('000000'\|\|OLD_COLUMN, length('000000'\|\|OLD_COLUMN)-5, 6);		update TABLE set NEW_COLUMN=substr('000000'\|\|OLD_COLUMN, length('000000'\|\|OLD_COLUMN)-5, 6);

2012-03-29T13:35:06Z

add formatting function for sqlite

← Older revision		Revision as of 13:35, 29 March 2012
Line 21:		Line 21:
	* column name used more than one time;		* column name used more than one time;
	* column name has reserved SQL word (depends on DB backend, see [http://www.petefreitag.com/tools/sql_reserved_words_checker/ SQL Reserved Words Checker] to quickly find out if a name is reserved)		* column name has reserved SQL word (depends on DB backend, see [http://www.petefreitag.com/tools/sql_reserved_words_checker/ SQL Reserved Words Checker] to quickly find out if a name is reserved)

			=== Formatting ===

			If your data should have values as character with zero but you have number leading zero (in the example it should be six number) in SQLite you can run
			alter table TABLE add column NEW_COLUMN text;
			update TABLE set NEW_COLUMN=substr('000000'\|\|OLD_COLUMN, length('000000'\|\|OLD_COLUMN)-5, 6);


	[[Category:FAQ]]		[[Category:FAQ]]

2011-03-17T15:09:27Z

+Analysing SQL syntax errors/table import or copy problems

@@ Line 7: / Line 7: @@
 * Using [[Openoffice.org with SQL Databases]]
 * [[SQL rename columns]]
 [[Category:FAQ]]

2010-12-14T11:12:20Z

fix man link

← Older revision		Revision as of 11:12, 14 December 2010
Line 3:		Line 3:
	GRASS 6 uses SQL for vector attribute management.		GRASS 6 uses SQL for vector attribute management.

	* ~~[http://grass.osgeo.org/grass63/manuals/html63_user/~~sql~~.html~~ Overview]		* {{cmd\|sql}} Overview of SQL in GRASS
	* ~~[http://grass.osgeo.org/grass63/manuals/html63_user/~~databaseintro~~.html~~ Database management]		* {{cmd\|databaseintro}} - Database management
	* Using [[Openoffice.org with SQL Databases]]		* Using [[Openoffice.org with SQL Databases]]
	* [[SQL rename columns]]		* [[SQL rename columns]]

	[[Category:FAQ]]		[[Category:FAQ]]

2008-01-22T08:07:24Z

urls updated

← Older revision		Revision as of 08:07, 22 January 2008
Line 3:		Line 3:
	GRASS 6 uses SQL for vector attribute management.		GRASS 6 uses SQL for vector attribute management.

	* [http://grass.~~itc~~.it/~~grass61~~/manuals/~~html61_user~~/sql.html Overview]		* [http://grass.osgeo.org/grass63/manuals/html63_user/sql.html Overview]
	* [http://grass.~~itc~~.it/~~grass61~~/manuals/~~html61_user~~/databaseintro.html Database management]		* [http://grass.osgeo.org/grass63/manuals/html63_user/databaseintro.html Database management]
	* Using [[Openoffice.org with SQL Databases]]		* Using [[Openoffice.org with SQL Databases]]
	* [[SQL rename columns]]		* [[SQL rename columns]]

	[[Category:FAQ]]		[[Category:FAQ]]

2007-02-09T23:50:33Z

SQL support in GRASS GIS

← Older revision		Revision as of 23:50, 9 February 2007
Line 6:		Line 6:
	* [http://grass.itc.it/grass61/manuals/html61_user/databaseintro.html Database management]		* [http://grass.itc.it/grass61/manuals/html61_user/databaseintro.html Database management]
	* Using [[Openoffice.org with SQL Databases]]		* Using [[Openoffice.org with SQL Databases]]
			* [[SQL rename columns]]

	[[Category:FAQ]]		[[Category:FAQ]]

2006-08-13T19:27:23Z

new page

← Older revision		Revision as of 19:27, 13 August 2006
Line 5:		Line 5:
	* [http://grass.itc.it/grass61/manuals/html61_user/sql.html Overview]		* [http://grass.itc.it/grass61/manuals/html61_user/sql.html Overview]
	* [http://grass.itc.it/grass61/manuals/html61_user/databaseintro.html Database management]		* [http://grass.itc.it/grass61/manuals/html61_user/databaseintro.html Database management]
			* Using [[Openoffice.org with SQL Databases]]

	[[Category:FAQ]]		[[Category:FAQ]]