1.连接符
||将左右两个字符串拼接起来
例:select id || name as fullid from app_user;
select * from app_user where name = 'admin' || #name#
2.字符串中包含引号
单引号用两个单引号代替
例: update app_user set name='admin''ooo''admin'
1.连接符
||将左右两个字符串拼接起来
例:select id || name as fullid from app_user;
select * from app_user where name = 'admin' || #name#
2.字符串中包含引号
单引号用两个单引号代替
例: update app_user set name='admin''ooo''admin'