리눅스, 자료실, 성경검색, 추억의게임, 고전게임, 오락실게임, rootman, http://www.rootman.co.kr
* 18.204.56.104 *
| Home | Profile | Linux | 자료실 | zabbix | Mysql 5.6 | 갤러리 | 성경검색 | 해피니스 | 자유게시판 | 게시물검색 | L | O | R |    

 
[sqlite] [sqlite] Type Conversions Prior To Comparison
 작성자 : rootman
Date : 2011-10-28 11:30  |  Hit : 4,297  


To "apply affinity" means to convert an operand to a particular storage class if and only if the conversion is lossless and reversible. Affinity is applied to operands of a comparison operator prior to the comparison according to the following rules in the order shown:

If one operand has INTEGER, REAL or NUMERIC affinity and the other operand as TEXT or NONE affinity then NUMERIC affinity is applied to other operand.

If one operand has TEXT affinity and the other has NONE affinity, then TEXT affinity is applied to the other operand.

Otherwise, no affinity is applied and both operands are compared as is.

The expression "a BETWEEN b AND c" is treated as two separate binary comparisons "a >= b AND a __EXPRESSION__s.</P>


 
 

Total. 19
번호 분류 제목 작성자 등록일 조회수
19 sqlite [sqlite3] 날짜와 시간 함수 알아보기 rootman 12-14 10347
18 sqlite [sqlite3] command, DB 전체를 dump export, dump import 하기 rootman 12-12 4913
17 sqlite [sqlite3] command, 외부로 import/export하기 rootman 12-12 4527
16 sqlite [sqlite] 유용한 함수들 rootman 11-22 6714
15 sqlite [sqlite] 반올림, 버림, 올림 함수 rootman 11-22 10487
14 sqlite [sqlite] I deleted a lot of data but the database file did n… rootman 10-28 4243
13 sqlite [sqlite] How do I add or delete columns from an existing tab… rootman 10-28 4238
12 sqlite [sqlite] Collation Sequence Examples rootman 10-28 4488
11 sqlite [sqlite] Assigning Collating Sequences from SQL rootman 10-28 4317
10 sqlite [sqlite] Collating Sequences rootman 10-28 4164
9 sqlite [sqlite] Sorting, Grouping and Compound SELECTs rootman 10-28 4260
8 sqlite [sqlite] Operators rootman 10-28 4140
7 sqlite [sqlite] Comparison Example rootman 10-28 4269
6 sqlite [sqlite] Type Conversions Prior To Comparison rootman 10-28 4298
5 sqlite [sqlite] Affinity Of Comparison Operands rootman 10-28 4320
 1  2  
AND OR