常用转义字符

提示:请直接按Ctrl+F搜索您要查找的转义字符

常用表

字符转义字符描述
''单引号
""双引号
&&
<&lt;
>&gt;
不断开空格(non-breaking space)&nbsp;空格
#&#35;
&&#38;
.&#46;句号
¥&yen;
¦&brvbar;
§&sect;
¨&uml;
©&copy;
«&laquo;
®&reg;
¼&frac14;
½&frac12;
¾&frac34;
$&#36;
%&#37;
(&#40;
)&#41;
*&#42;
+&#43;
,&#44;逗号
:&#58;冒号
;&#59;分号
=&#61;
-&#45;连字号
/&#47;斜杠
\&#92;反斜杠
|&#124;竖杠
¦&#166;断竖杠
[&#91;
]&#93;
^&#94;
_&#95;下划线
`&#96;尖重音符

ISO 8859-1 characters

char glyph HTML tag
空格 &nbsp;
¡ &iexcl;
¢ &cent;
£ &pound;
¤ &curren;
¥ &yen;
¦ &brvbar;
§ &sect;
¨ &uml;
© &copy;
ª &ordf;
« &laquo;
¬ &not;
&shy;
® &reg;
¯ &macr;
° &deg;
± &plusmn;
² &sup2;
³ &sup3;
´ &acute;
µ &micro;
&para;
· &middot;
¸ &cedil;
¹ &sup1;
º &ordm;
» &raquo;
¼ &frac14;
½ &frac12;
¾ &frac34;
¿ &iquest;
À &Agrave;
Á &Aacute;
 &Acirc;
à &Atilde;
Ä &Auml;
Å &Aring;
Æ &AElig;
Ç &Ccedil;
È &Egrave;
É &Eacute;
Ê &Ecirc;
Ë &Euml;
Ì &Igrave;
Í &Iacute;
Î &Icirc;
Ï &Iuml;
Ð &ETH;
Ñ &Ntilde;
Ò &Ograve;
Ó &Oacute;
Ô &Ocirc;
Õ &Otilde;
Ö &Ouml;
× &times;
Ø &Oslash;
Ù &Ugrave;
Ú &Uacute;
Û &Ucirc;
Ü &Uuml;
Ý &Yacute;
Þ &THORN;
ß &szlig;
à &agrave;
á &aacute;
â &acirc;
ã &atilde;
ä &auml;
å &aring;
æ &aelig;
ç &ccedil;
è &egrave;
é &eacute;
ê &ecirc;
ë &euml;
ì &igrave;
í &iacute;
î &icirc;
ï &iuml;
ð &eth;
ñ &ntilde;
ò &ograve;
ó &oacute;
ô &ocirc;
õ &otilde;
ö &ouml;
÷ &divide;
ø &oslash;
ù &ugrave;
ú &uacute;
û &ucirc;
ü &uuml;
ý &yacute;
þ &thorn;
ÿ &yuml;

Math symbols

Latin Extended-B
char glyph HTML tag
ƒ &fnof;

Arrows
char glyph HTML tag
&larr;
&uarr;
&rarr;
&darr;
&harr;
&crarr;
&lArr;
&uArr;
&rArr;
&dArr;
&hArr;

Mathematical Operators
char glyph HTML tag
&forall;
&part;
&exist;
&empty;
&nabla;
&isin;
&notin;
&ni;
&prod;
&sum;
&minus;
&lowast;
&radic;
&prop;
&infin;
&ang;
&and;
&or;
&cap;
&cup;
&int;
&there4;
&sim;
&cong;
&asymp;
&ne;
&equiv;
&le;
&ge;
&sub;
&sup;
&nsub;
&sube;
&supe;
&oplus;
&otimes;
&perp;
&sdot;

General Punctuation
char glyph HTML tag
&bull;
&hellip;
&prime;
&Prime;
&oline;
&frasl;

Miscellaneous Technical
char glyph HTML tag
&lceil;
&rceil;
&lfloor;
&rfloor;
&lang;
&rang;

Geometric Shapes
char glyph HTML tag
&loz;

Miscellaneous Symbols
char glyph HTML tag
&spades;
&clubs;
&hearts;
&diams;


Letterlike Symbols
char glyph HTML tag
&weierp;
&image;
&real;
&trade;
&alefsym;

Greek
char glyph HTML tag
Α &Alpha;
Β &Beta;
Γ &Gamma;
Δ &Delta;
Ε &Epsilon;
Ζ &Zeta;
Η &Eta;
Θ &Theta;
Ι &Iota;
Κ &Kappa;
Λ &Lambda;
Μ &Mu;
Ν &Nu;
Ξ &Xi;
Ο &Omicron;
Π &Pi;
Ρ &Rho;
Σ &Sigma;
Τ &Tau;
Υ &Upsilon;
Φ &Phi;
Χ &Chi;
Ψ &Psi;
Ω &Omega;
α &alpha;
β &beta;
γ &gamma;
δ &delta;
ε &epsilon;
ζ &zeta;
η &eta;
θ &theta;
ι &iota;
κ &kappa;
λ &lambda;
μ &mu;
ν &nu;
ξ &xi;
ο &omicron;
π &pi;
ρ &rho;
ς &sigmaf;
σ &sigma;
τ &tau;
υ &upsilon;
φ &phi;
χ &chi;
ψ &psi;
ω &omega;
ϑ &thetasym;
ϒ &upsih;
ϖ &piv;

Special characters for HTML

C0 Controls and Basic Latin
char glyph HTML tag
" &quot;
& &amp;
< &lt;
> &gt;

Latin Extended-A
char glyph HTML tag
Π&OElig;
œ &oelig;
Š &Scaron;
š &scaron;
Ÿ &Yuml;

Spacing Modifier Letters
char glyph HTML tag
ˆ &circ;
˜ &tilde;

General Punctuation
char glyph HTML tag
&ensp;
&emsp;
&thinsp;
&zwnj;
&zwj;
&lrm;
&rlm;
&ndash;
&mdash;
&lsquo;
&rsquo;
&sbquo;
&ldquo;
&rdquo;
&bdquo;
&dagger;
&Dagger;
&permil;
&lsaquo;
&rsaquo;
&euro;
  • 1
    点赞
  • 8
    收藏
    觉得还不错? 一键收藏
  • 0
    评论
MySQL常用转义字符是反引号(`)。它用于避免与MySQL的关键字冲突,并且通常用于引用数据库名、表名和字段名。例如,如果要查询一个名为"from"的字段,可以使用`from`来转义它,以示它是一个字段名而不是关键字。\[1\]其他常见的转义字符包括单引号(')、双引号(")和反斜杠(\),它们在插入和查询数据时用于转义特殊字符。例如,如果要插入一个包含单引号的值,可以使用反斜杠进行转义,如\'。\[2\]在PHP中,可以使用addslashes()函数来在预定义字符之前添加反斜杠,以防止注入攻击中使用单引号。\[3\]总之,反引号(`)是MySQL中常用转义字符,用于引用数据库名、表名和字段名,而单引号(')、双引号(")和反斜杠(\)用于转义特殊字符。 #### 引用[.reference_title] - *1* [MYSQL 转义字符](https://blog.csdn.net/weixin_43547220/article/details/120788261)[target="_blank" data-report-click={"spm":"1018.2226.3001.9630","extra":{"utm_source":"vip_chatgpt_common_search_pc_result","utm_medium":"distribute.pc_search_result.none-task-cask-2~all~insert_cask~default-1-null.142^v91^insertT0,239^v3^insert_chatgpt"}} ] [.reference_item] - *2* *3* [mysql-转义字符](https://blog.csdn.net/qq_32258499/article/details/130030158)[target="_blank" data-report-click={"spm":"1018.2226.3001.9630","extra":{"utm_source":"vip_chatgpt_common_search_pc_result","utm_medium":"distribute.pc_search_result.none-task-cask-2~all~insert_cask~default-1-null.142^v91^insertT0,239^v3^insert_chatgpt"}} ] [.reference_item] [ .reference_list ]

“相关推荐”对你有帮助么?

  • 非常没帮助
  • 没帮助
  • 一般
  • 有帮助
  • 非常有帮助
提交
评论
添加红包

请填写红包祝福语或标题

红包个数最小为10个

红包金额最低5元

当前余额3.43前往充值 >
需支付:10.00
成就一亿技术人!
领取后你会自动成为博主和红包主的粉丝 规则
hope_wisdom
发出的红包
实付
使用余额支付
点击重新获取
扫码支付
钱包余额 0

抵扣说明:

1.余额是钱包充值的虚拟货币,按照1:1的比例进行支付金额的抵扣。
2.余额无法直接购买下载,可以购买VIP、付费专栏及课程。

余额充值