在SQLite下
select "A"+"1" 结果为1
select "A"+1 结果为1
select 2+1 结果为3
以应该用|| 来拼接字符串的结果
select "A"+"1" 结果为1
select "A"+1 结果为1
select 2+1 结果为3
以应该用|| 来拼接字符串的结果
select "A"||ID AS MyStr from table1;
select "A"||ID AS MyStr from table1;