You are viewing a plain text version of this content. The canonical link for it is here.
Posted to dev@kylin.apache.org by May Zhou <ma...@foxmail.com> on 2018/12/19 08:10:57 UTC

回复：use single quote in sql ,how to escape

Hi Yunyao,
    I'm afraid your attached picture does not show up normally. 
    And could you describe your question more detailedly ? Are you using sql contains single quote in the Insight page of Kylin instance, or are you trying to send a query by REST API?
   
    Does backslash '\' work for your situation?


BRs,
May




------------------ 原始邮件 ------------------
发件人: "黄云尧"<yu...@transsnet.com>;
发送时间: 2018年12月19日(星期三) 下午4:00
收件人: "dev"<de...@kylin.apache.org>;

主题: use single quote in sql ,how to escape




I am looking forward to your reply

Re:回复：use single quote in sql ,how to escape

Posted by 黄云尧 <yu...@transsnet.com>.
look the sql :             select * from buzz_info where title like '%hello i' am kangkan%'<br/><br/><br/>but it is a worry grammar,how to escape by use single quote.
发件人：May Zhou <ma...@foxmail.com>
发送日期：2018-12-19 16:10:57
收件人：dev <de...@kylin.apache.org>
主题：回复：use single quote in sql ,how to escape>Hi Yunyao,
>    I'm afraid your attached picture does not show up normally. 
>    And could you describe your question more detailedly ? Are you using sql contains single quote in the Insight page of Kylin instance, or are you trying to send a query by REST API?
>   
>    Does backslash '\' work for your situation?
>
>
>BRs,
>May
>
>
>
>
>------------------ 原始邮件 ------------------
>发件人: "黄云尧"<yu...@transsnet.com>;
>发送时间: 2018年12月19日(星期三) 下午4:00
>收件人: "dev"<de...@kylin.apache.org>;
>
>主题: use single quote in sql ,how to escape
>
>
>
>
>I am looking forward to your reply