答案:http://www.sqlite.org/lang_corefunc.html 根据官方主页目前没有concat函数 有substr ,但是没有concat substr(X,Y,Z) substr(X,Y) The substr(X,Y,Z) function returns a substring of input string X that begins with the Y-th character and which is Z characters long. If Z is omitted then substr(X,Y) returns all characters through the end of the string X beginning with the Y-th. The left-most character of X is number 1. If Y is negative then the first character of the substring is found by counting from the right rather than the left. If Z is negative then the abs(Z) characters preceding the Y-th character are returned. If X is a string then characters indices refer to actual UTF-8 characters. If X is a BLOB then the indices refer to bytes.
其他:sqlite的concat可以用||替代
比如:
select concat('a', 'b') as mix;
换成
select 'a'||'b' as mix;
上一个:Excel 转换为 Access 或 SQLite
下一个:QT连接sqlite操作具体怎么实现?最好在代码里加上注释