1、mysql----"||" 运算符 或者
select 1=1 or 1=0 from dual; -- 1
select 1=1 or 1=1 from dual; -- 1
select 1=0 or 1=0 from dual; -- 0
select 1=0 or 1=1 from dual; -- 1
select 1=1 || 1=0 from dual; -- 1
select 1=1 || 1=1 from dual; -- 1
select 1=0 || 1=0 from dual; -- 0
select 1=0 || 1=1 from dual; -- 1
select '你' || '好' from dual; -- 0
select '你' OR '好' from dual; -- 0
select case when '好' then 1 else 0 end from dual; -- 0
select case when '好' then 0 else 1 end from dual; -- 1
2、mysql中concat函数,连接多个
select concat('你','好','吗') from dual; -- 你好吗
3、oracle---concat只能连接两个字符串
select concat('你','好') from dual; -- 你好
4、oracle---"||"连接多个
select '你'||'好'||'吗' from dual; -- 你好吗