SQLite Reference - Revision history

Ghenne at 21:10, 17 March 2019

2019-03-17T21:10:45Z

← Older revision		Revision as of 21:10, 17 March 2019
Line 1:		Line 1:
	The information in the document is for the most part copied from the official [http://www.sqlite.org/lang.html SQLite documentation].		The information in the document is for the most part copied from the official [http://www.sqlite.org/lang.html SQLite documentation].

	In general, these commands are called using the <code>Sql</code> function. See the [~~TN15.htm~~ Tech Note on SQLite] for more information on using SQLite ~~from NS Basic~~.		In general, these commands are called using the <code>Sql</code> function. See the [[Using SQLite\|Tech Note on SQLite]] for more information on using SQLite with AppStudio.

	=== ALTER TABLE ===		=== ALTER TABLE ===

Ghenne: /* expression */

2012-11-10T14:13:32Z

expression

← Older revision		Revision as of 14:13, 10 November 2012
Line 568:		Line 568:
	\| valign="top" \| Return a copy of the first non-NULL argument. If all arguments are NULL then NULL is returned. There must be at least 2 arguments.		\| valign="top" \| Return a copy of the first non-NULL argument. If all arguments are NULL then NULL is returned. There must be at least 2 arguments.
	\|-		\|-
	\|
	\| align="right" valign="top" \| glob(''X'',''Y'')		\| align="right" valign="top" \| glob(''X'',''Y'')
	\| valign="top" \|		\| valign="top" \|
Line 582:		Line 581:
	\| valign="top" \| Return the string length of ''X'' in characters. If SQLite is configured to support UTF-8, then the number of UTF-8 characters is returned, not the number of bytes.		\| valign="top" \| Return the string length of ''X'' in characters. If SQLite is configured to support UTF-8, then the number of UTF-8 characters is returned, not the number of bytes.
	\|-		\|-
	\|
	\| align="right" valign="top" \| like(''X'',''Y'' [,''Z''])		\| align="right" valign="top" \| like(''X'',''Y'' [,''Z''])
	\| valign="top" \|		\| valign="top" \|

Ghenne at 14:10, 10 November 2012

2012-11-10T14:10:56Z

← Older revision		Revision as of 14:10, 10 November 2012
Line 535:		Line 535:
	Parameters that are not assigned values using [http://www.sqlite.org/capi3ref.html#sqlite3_bind_int sqlite3_bind] are treated as NULL.		Parameters that are not assigned values using [http://www.sqlite.org/capi3ref.html#sqlite3_bind_int sqlite3_bind] are treated as NULL.

	The LIKE operator does a pattern matching comparison. The operand to the right contains the pattern, the left hand operand contains the string to match against the pattern. A percent symbol <font color="#2c2cf0"><big>%</big></font> in the pattern matches any sequence of zero or more characters in the string. An underscore <font color="#2c2cf0"><big>_</big></font> in the pattern matches any single character in the string. Any other character matches itself or it's lower/upper case equivalent (i.e. case-insensitive matching). (A bug: SQLite only understands upper/lower case for 7-bit Latin characters. Hence the LIKE operator is case sensitive for 8-bit iso8859 characters or UTF-8 characters. For example, the expression ''''a' LIKE 'A'''' is TRUE but ''''Ã¦' LIKE 'Ã†'''' is FALSE.).		The LIKE operator does a pattern matching comparison. The operand to the right contains the pattern, the left hand operand contains the string to match against the pattern. A percent symbol <font color="#2c2cf0"><big>%</big></font> in the pattern matches any sequence of zero or more characters in the string. An underscore <font color="#2c2cf0"><big>_</big></font> in the pattern matches any single character in the string. Any other character matches itself or it's lower/upper case equivalent (i.e. case-insensitive matching). (A bug: SQLite only understands upper/lower case for 7-bit Latin characters. Hence the LIKE operator is case sensitive for 8-bit iso8859 characters or UTF-8 characters. For example, the expression ''''a' LIKE 'A'''' is TRUE but '''' ¦' LIKE ' †'''' is FALSE.).

	If the optional ESCAPE clause is present, then the expression following the ESCAPE keyword must evaluate to a string consisting of a single character. This character may be used in the LIKE pattern to include literal percent or underscore characters. The escape character followed by a percent symbol, underscore or itself matches a literal percent symbol, underscore or escape character in the string, respectively. The infix LIKE operator is implemented by calling the user function [#likeFunc like(''X'',''Y'')].		If the optional ESCAPE clause is present, then the expression following the ESCAPE keyword must evaluate to a string consisting of a single character. This character may be used in the LIKE pattern to include literal percent or underscore characters. The escape character followed by a percent symbol, underscore or itself matches a literal percent symbol, underscore or escape character in the string, respectively. The infix LIKE operator is implemented by calling the user function [#likeFunc like(''X'',''Y'')].

	The LIKE operator is not case sensitive and will match upper case characters on one side against lower case characters on the other. (A bug: SQLite only understands upper/lower case for 7-bit Latin characters. Hence the LIKE operator is case sensitive for 8-bit iso8859 characters or UTF-8 characters. For example, the expression ''''a' LIKE 'A'''' is TRUE but ''''Ã¦' LIKE 'Ã†'''' is FALSE.).		The LIKE operator is not case sensitive and will match upper case characters on one side against lower case characters on the other. (A bug: SQLite only understands upper/lower case for 7-bit Latin characters. Hence the LIKE operator is case sensitive for 8-bit iso8859 characters or UTF-8 characters. For example, the expression ''''a' LIKE 'A'''' is TRUE but '''' ¦' LIKE ' †'''' is FALSE.).

	The infix LIKE operator is implemented by calling the user function [#likeFunc like(''X'',''Y'')]. If an ESCAPE clause is present, it adds a third parameter to the function call. If the functionality of LIKE can be overridden by defining an alternative implementation of the like() SQL function.		The infix LIKE operator is implemented by calling the user function [#likeFunc like(''X'',''Y'')]. If an ESCAPE clause is present, it adds a third parameter to the function call. If the functionality of LIKE can be overridden by defining an alternative implementation of the like() SQL function.

Ghenne at 14:09, 10 November 2012

2012-11-10T14:09:27Z

Show changes

Ghenne at 14:07, 10 November 2012

2012-11-10T14:07:59Z

← Older revision		Revision as of 14:07, 10 November 2012
Line 2:		Line 2:

	In general, these commands are called using the <code>Sql</code> function. See the [TN15.htm Tech Note on SQLite] for more information on using SQLite from NS Basic.		In general, these commands are called using the <code>Sql</code> function. See the [TN15.htm Tech Note on SQLite] for more information on using SQLite from NS Basic.

	~~SQLite contains the follow commands:~~

	* [#lang_altertable ALTER TABLE]
	* [#lang_analyze ANALYZE]
	* [#lang_attach ATTACH DATABASE]
	* [#lang_transaction BEGIN TRANSACTION]
	* [#lang_comment comment]
	* [#lang_transaction COMMIT TRANSACTION]
	* [#lang_copy COPY]
	* [#lang_createindex CREATE INDEX]
	* [#lang_createtable CREATE TABLE]
	* [#lang_createtrigger CREATE TRIGGER]
	* [#lang_createview CREATE VIEW]
	* [#lang_delete DELETE]
	* [#lang_detach DETACH DATABASE]
	* [#lang_dropindex DROP INDEX]
	* [#lang_droptable DROP TABLE]
	* [#lang_droptrigger DROP TRIGGER]
	* [#lang_dropview DROP VIEW]
	* [#lang_transaction END TRANSACTION]
	* [#lang_explain EXPLAIN]
	* [#lang_expr expression]
	* [#lang_keywords keywords]
	* [#lang_insert INSERT]
	* [#lang_conflict ON CONFLICT clause]
	* [#pragma PRAGMA]
	* [#lang_reindex REINDEX]
	* [#lang_replace REPLACE]
	* [#lang_transaction ROLLBACK TRANSACTION]
	* [#lang_select SELECT]
	* [#lang_update UPDATE]
	* [#lang_vacuum VACUUM]

	----		----

Ghenne: Created page with "The information in the document is for the most part copied from the official [http://www.sqlite.org/lang.html SQLite documentation]. In general, these commands are called us..."

2012-11-10T14:07:25Z

Created page with "The information in the document is for the most part copied from the official [http://www.sqlite.org/lang.html SQLite documentation]. In general, these commands are called us..."

Show changes

← Older revision		Revision as of 14:13, 10 November 2012
Line 568:		Line 568:
	\| valign="top" \| Return a copy of the first non-NULL argument. If all arguments are NULL then NULL is returned. There must be at least 2 arguments.		\| valign="top" \| Return a copy of the first non-NULL argument. If all arguments are NULL then NULL is returned. There must be at least 2 arguments.
	\|-		\|-
	\|
	\| align="right" valign="top" \| glob(''X'',''Y'')		\| align="right" valign="top" \| glob(''X'',''Y'')
	\| valign="top" \|		\| valign="top" \|
Line 582:		Line 581:
	\| valign="top" \| Return the string length of ''X'' in characters. If SQLite is configured to support UTF-8, then the number of UTF-8 characters is returned, not the number of bytes.		\| valign="top" \| Return the string length of ''X'' in characters. If SQLite is configured to support UTF-8, then the number of UTF-8 characters is returned, not the number of bytes.
	\|-		\|-
	\|
	\| align="right" valign="top" \| like(''X'',''Y'' [,''Z''])		\| align="right" valign="top" \| like(''X'',''Y'' [,''Z''])
	\| valign="top" \|		\| valign="top" \|