Sqlite3 - Revision history

Pchero: /* ALTER TABLE */

2017-03-22T01:08:35Z

ALTER TABLE

← Older revision		Revision as of 01:08, 22 March 2017
Line 232:		Line 232:

	ALTER TABLE OLD_COMPANY ADD COLUMN SEX char(1);		ALTER TABLE OLD_COMPANY ADD COLUMN SEX char(1);
			</source>

			=== JOIN ===
			==== CROSS JOIN ====
			두 개의
			<source lang=sql>
			sqlite> select dial_mode, type from ob_plan cross join ob_destination;

			dial_mode\|type
			1\|1
			0\|1
			0\|1
			1\|1
			</source>

			==== INNER JOIN ====
			A INNER JOIN creates a new result table by combining column values of two tables(table1 and table2) based upon the join-predicate. The query compares each row of table1 with each row of table2 to find all pairs of rows which satisfy the join-oredicate. When the join-predicate is satisfied, column values for each matched pair of rows of A and B are combined into a result row.
			<pre>
			</pre>

			==== OUTER JOIN ====
			The OUTER JOIN is an extension of the INNER JOIN. Though SQL standard defines three types of OUTER JOINs(LEFT, RIGHT, FULL). But the SQLite only supports the LEFT OUTER JOIN.
			<source lang=sql>

	</source>		</source>

2017-02-10T12:39:47Z

INSERT

2017-02-10T12:23:16Z

INSERT

← Older revision		Revision as of 12:23, 10 February 2017
Line 191:		Line 191:
	[[File:Insert-stmt.gif]]		[[File:Insert-stmt.gif]]

			==== Example ====
	<source lang=sql>		<source lang=sql>
	INSERT INTO COMPANY (ID,NAME,AGE,ADDRESS,SALARY) VALUES (1, 'Paul', 32, 'California', 20000.00 );		INSERT INTO COMPANY (ID,NAME,AGE,ADDRESS,SALARY) VALUES (1, 'Paul', 32, 'California', 20000.00 );
Line 203:		Line 204:

	INSERT INTO COMPANY (ID,NAME,AGE,ADDRESS,SALARY) VALUES (6, 'Kim', 22, 'South-Hall', 45000.00 );		INSERT INTO COMPANY (ID,NAME,AGE,ADDRESS,SALARY) VALUES (6, 'Kim', 22, 'South-Hall', 45000.00 );

			INSERT OR REPLACE INTO COMPANY (ID,NAME,AGE,ADDRESS,SALARY) VALUES (6, 'Kim', 22, 'New-York', 45000.00 );
	</source>		</source>

2016-10-17T09:19:19Z

Pragma

@@ Line 145: / Line 145: @@
 == Pragma ==
-=== List ===
+[[Sqlite3-pragma]] 항목 참조.
 == Statement ==

2016-10-17T09:16:38Z

Pragma

← Older revision		Revision as of 09:16, 17 October 2016
Line 145:		Line 145:

	== Pragma ==		== Pragma ==
			=== List ===
			전체 pragma 목록.
			<pre>

			</pre>

	=== table_info() ===		=== table_info() ===
	입력된 table 의 정보를 출력한다. 각각의 라인마다 테이블에 있는 모든 칼럼과 속성을 하나씩 출력한다. table 뿐만 아니라 view 정보도 확인할 수 있다. 각각의 항목별 내용은 아래 순서와 같다.		입력된 table 의 정보를 출력한다. 각각의 라인마다 테이블에 있는 모든 칼럼과 속성을 하나씩 출력한다. table 뿐만 아니라 view 정보도 확인할 수 있다. 각각의 항목별 내용은 아래 순서와 같다.

2016-10-17T09:13:07Z

Pchero moved page Sqlite3-server to Sqlite3 over redirect

← Older revision	Revision as of 09:13, 17 October 2016
(No difference)

2016-10-17T09:12:35Z

Pchero moved page Sqlite3 to Sqlite3-server

← Older revision	Revision as of 09:12, 17 October 2016
(No difference)

2016-10-17T09:12:13Z

Pragma

← Older revision		Revision as of 09:12, 17 October 2016
Line 154:		Line 154:
	* Primary key 여부		* Primary key 여부
	<pre>		<pre>
	sqlite> pragma table_info(~~test~~);		sqlite> pragma table_info(plan);
	0\|~~seq~~\|~~integer~~\|0\|\|1		0\|uuid\|varchar(255)\|1\|\|1
	1\|~~uniq_id~~\|~~text~~\|1\|\|0		1\|name\|varchar(255)\|0\|null\|0
	</pre>		</pre>

			=== jounal_mode ===

	== Statement ==		== Statement ==

2016-10-17T08:31:01Z

References

2016-10-14T23:47:19Z

← Older revision		Revision as of 23:47, 14 October 2016
Line 267:		Line 267:
	0\|0\|TABLE sms WITH INDEX sms_on_going		0\|0\|TABLE sms WITH INDEX sms_on_going
	</source>		</source>

			== Errors ==
			=== unfinalized ===
			sqlite3_close() 시, 다음과 같이 unfinalized 에러가 나올 경우, sqlite3_finalize() 를 호출해서 강제로 종료할 수 있다.
			<pre>
			unable to close due to unfinalized statements or unfinished backups
			</pre>
			* http://stackoverflow.com/questions/373369/sqlite3unable-to-close-due-to-unfinalised-statements

	== See also ==		== See also ==