SQLite String concatenation

From http://blog.csdn.net/zhjp4295216/article/details/5776954

 

Select path | '%' from t_category where depth = 0 and type = 0

Concatenate a string with '|'

For example, if path is/1001/, the result is/1001/%.

 

Number Addition

select 'A' + 'B' the result is 0

select " A "+" 1 " the result is 1

select " A "+ 1 the result is 1

Select2 + 1Result 3

= In the "+" operation, SQLite treats non-numeric strings of strings as 0.

 

| String concatenation
* Arithmetic multiply
/ Arithmetic divide
% Arithmetic Modulus
+ Arithmetic add
- Arithmetic subtract
< Bitwise right shift
> Bitwise left shift
& Logical and
| Logical or
< Relational less
<= Relational less than or equal
> Relational greater
> = Relational greater than or equal
= Relational equal
= Relational equal
<> Relational not equal
! = Relational not equal
In Logical in
And Logical and
Or Logical or
Like Relational String Matching
Glob Relational filename matching