6.02 字符串文字中包含引号

create table t1 as select ename from emp where ename='KING';
select 'g''day mate' quarks from t1 union all
select 'beavers'' teeth' from t1 union all
select '''' from t1;

+----------------+
| quarks         |
+----------------+
| g'day mate       |
| beavers' teeth   |
| '                      |
+----------------+

转载于:https://www.cnblogs.com/liang545621/p/7518764.html