sqlite字符串拼接
来源:互联网 发布:乳胶沙发品牌知乎 编辑:程序博客网 时间:2024/06/04 23:32
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
- sqlite字符串拼接
- SQLite字符串拼接
- 拼接字符串:
- 字符串拼接
- 字符串拼接
- 字符串拼接
- 字符串拼接
- 拼接字符串
- 拼接字符串
- 拼接字符串
- 拼接字符串
- 字符串拼接
- 拼接字符串
- 字符串拼接
- 字符串拼接
- 拼接字符串
- 字符串拼接
- 字符串拼接
- Posix线程编程指南(4)
- ASP.net中用C#开发搜索引擎蜘蛛程
- 内存映射文件
- 监听JComponent显示事件
- LaTeX Example
- sqlite字符串拼接
- 二级指针与二级数组汇总
- web.xml加入taglib报错
- VC 图像控件 图像显示
- repaint window caption
- 我配置的ant,build.xml文件用于导入到EJB
- 【动态规划】最大连续序列和最大子矩阵
- Nested Class
- 高维数组的理解