wordpress - 在wordpress博客中格式化sql查询的正确方法是什么？

Question

我正在尝试将其插入我的 wqordpress 博客中，我尝试使用 with [sourcecode language="bash"] apt-get update [/sourcecode]it 工作

[sourcecode language="sql"]  
create external schema spectrum 
from data catalog 
database 'spectrumdb' 
iam_role 'arn:aws:iam::123456789012:role/mySpectrumRole'
create external database if not exists;
[/sourcecode]

但由于预览中的一些奇怪原因，它显示了一些额外的编码

<span class="hljs-keyword">create</span> <span class="hljs-keyword">external</span> <span class="hljs-keyword">schema</span> spectrum 
<span class="hljs-keyword">from</span> <span class="hljs-keyword">data</span> <span class="hljs-keyword">catalog</span> 
<span class="hljs-keyword">database</span> <span class="hljs-string">'spectrumdb'</span> 
iam_role <span class="hljs-string">'arn:aws:iam::123456789012:role/mySpectrumRole'</span>
<span class="hljs-keyword">create</span> <span class="hljs-keyword">external</span> <span class="hljs-keyword">database</span> <span class="hljs-keyword">if</span> <span class="hljs-keyword">not</span> <span class="hljs-keyword">exists</span>;

标签： wordpressblogscode-formatting

Answer 1

这对我有用

[sql]  
create external schema spectrum 
from data catalog 
database 'spectrumdb' 
iam_role 'arn:aws:iam::123456789012:role/mySpectrumRole'
create external database if not exists;
[/sql]