c mysql 导入反斜杠_MySQL没有插入反斜杠

MySQL中,当我尝试在我的表中插入一个反斜杠,它不接受它,并给我没有反斜杠的内容.

id设置为自动递增:

码:

INSERT INTO gender (sex, date) VALUES (

'male are allowed \ female are not allowed', "2012-10-06")

如何插入文字反斜杠?

关于转义序列的注意事项:

Escape Sequence Character Represented by Sequence

\0 An ASCII NUL (0x00) character.

\' A single quote (“'”) character.

\" A double quote (“"”) character.

\b A backspace character.

\n A newline (linefeed) character.

\r A carriage return character.

\t A tab character.

\Z ASCII 26 (Control+Z). See note following the table.

\\ A backslash (“\”) character.

\% A “%” character. See note following the table.

\_ A “_” character. See note following the table.

评论
添加红包

请填写红包祝福语或标题

红包个数最小为10个

红包金额最低5元

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

抵扣说明:

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

余额充值