sqlite字符串拼接

最新推荐文章于 2024-08-10 23:17:37 发布

zhjp4295216

最新推荐文章于 2024-08-10 23:17:37 发布

阅读量1w

点赞数

分类专栏： android DB--SQLITE 文章标签： sqlite concatenation less string path

本文链接：https://blog.csdn.net/zhjp4295216/article/details/5776954

版权

android DB--SQLITE 专栏收录该内容

41 篇文章 0 订阅

订阅专栏

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

用'||'拼接字符串

比如path是/1001/的话那结果就是/1001/%

数字相加

SELECT 'A'+'B'
结果为0
select "A"+"1" 结果为1
select "A"+1 结果为1
select 2+1 结果为3

=在“+”运算中，SQLite将字符串非数字串都当作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 than
<= Relational Less than or equal to
> Relational Greater than
>= Relational Greater than or equal to
= Relational Equal to
== Relational Equal to
<> Relational Not equal to
!= Relational Not equal to
IN Logical In
AND Logical And
OR Logical Or
LIKE Relational String matching
GLOB Relational Filename matching