blocks|key|5910133|text|“我的家人...”这句话有点奇怪。这看起来像是一个复制-粘贴-错误。如果此字段的类型为VARCHAR，则必须将意义移到简单撇号中|type|unstyled|depth|inlineStyleRanges|offset|length|style|CODE|entityRanges|data|5910134|5910135|‘我和我的家人永远不会忘记2017年1月20日星期五。谢谢！’|blockquote|5910136|5910137|5910138|您的代码行被解释为|5910139|'b‘：VARCHAR字段|BOLD|5910140|我和我的家人永远不会忘记2017年1月20日星期五。：一些SQL语法|5910141|'‘：VARCHAR字段|5910142|这显然行不通。一个正常工作的INSERT应该是这样的：|5910143|INSERT+INTO+fb_public_figure_posts
+++++++VALUES+(
++++++++++'153080620724_10158531267690725',
++++++++++'https://www.facebook.com/DonaldTrump/videos/10158531267690725/',
++++++++++'2017-01-23T20:36:07%2B0000',
++++++++++'2017-01-24T00:22:49%2B0000',
++++++++++'Donald+J.+Trump',
++++++++++153080620724,
++++++++++'My+family+and+I+will+never+forget+Friday,+January+20th,+2017.+Thank+you!',
++++++++++'https://www.facebook.com/DonaldTrump/videos/10158531267690725/',
++++++++++123471,
++++++++++8263,
++++++++++153080620724
+++++++++++++);|code-block|syntax|javascript|5910144|entityMap^0|17|7|0|0|0|0|0|0|3|A|0|Q|8|0|2|A|0|E|6|0|0^^$0|@$1|2|3|4|5|6|7|13|8|@$9|14|A|15|B|C]]|D|@]|E|$]]|$1|F|3|-4|5|6|7|16|8|@]|D|@]|E|$]]|$1|G|3|H|5|I|7|17|8|@]|D|@]|E|$]]|$1|J|3|-4|5|6|7|18|8|@]|D|@]|E|$]]|$1|K|3|-4|5|6|7|19|8|@]|D|@]|E|$]]|$1|L|3|M|5|6|7|1A|8|@]|D|@]|E|$]]|$1|N|3|O|5|6|7|1B|8|@$9|1C|A|1D|B|P]]|D|@]|E|$]]|$1|Q|3|R|5|6|7|1E|8|@$9|1F|A|1G|B|P]]|D|@]|E|$]]|$1|S|3|T|5|6|7|1H|8|@$9|1I|A|1J|B|P]]|D|@]|E|$]]|$1|U|3|V|5|6|7|1K|8|@$9|1L|A|1M|B|C]]|D|@]|E|$]]|$1|W|3|X|5|Y|7|1N|8|@]|D|@]|E|$Z|10]]|$1|11|3|-4|5|6|7|1O|8|@]|D|@]|E|$]]]|12|$]]

The line with the 'My family...'-sentence is a bit weird. This looks like a copy-paste-error. If this field has the type of <code>VARCHAR</code> you have to move the sentance in the simple apostrophe 

<blockquote>
 'My family and I will never forget Friday, January 20th, 2017. Thank you!'
</blockquote>

Your line is interpreted as 

'b' : VARCHAR field

My family and I will never forget Friday, January 20th, 2017. Thank you! : some SQL-Syntax

'' : VARCHAR field

which can't obviously work.
A working <code>INSERT</code> would look like this:

<pre><code>INSERT INTO fb_public_figure_posts
 VALUES (
 '153080620724_10158531267690725',
 'https://www.facebook.com/DonaldTrump/videos/10158531267690725/',
 '2017-01-23T20:36:07+0000',
 '2017-01-24T00:22:49+0000',
 'Donald J. Trump',
 153080620724,
 'My family and I will never forget Friday, January 20th, 2017. Thank you!',
 'https://www.facebook.com/DonaldTrump/videos/10158531267690725/',
 123471,
 8263,
 153080620724
 );
</code></pre>

blocks|key|4442286|text|问题是，您试图插入到数据库中的字符串中只有一个引号。您的INSERT语句中缺少单引号。在将文本放入INSERT语句之前，需要对任何单引号进行转义。|type|unstyled|depth|inlineStyleRanges|entityRanges|data|4442287|请参阅上一篇文章"How+to+escape+apostrophe+(')+in+MySql?"|offset|length|4442288|entityMap|0|LINK|mutability|MUTABLE|url|https://stackoverflow.com/questions/9596652/how-to-escape-apostrophe-in-mysql^0|0|8|14|0|0^^$0|@$1|2|3|4|5|6|7|N|8|@]|9|@]|A|$]]|$1|B|3|C|5|6|7|O|8|@]|9|@$D|P|E|Q|1|R]]|A|$]]|$1|F|3|-4|5|6|7|S|8|@]|9|@]|A|$]]]|G|$H|$5|I|J|K|A|$L|M]]]]

The problem is that you have a single quotation in the string you are trying to insert into your database. The single quotation is missing up your INSERT statement. Before putting the text into your INSERT statement, you need to escape any single quotation. 

Refer to this previous post <a href="https://stackoverflow.com/questions/9596652/how-to-escape-apostrophe-in-mysql">"How to escape apostrophe (') in MySql?"</a>

blocks|key|5910219|text|您的sql不正确。'b'M...+'+is+unnecessary.and+...Thank+you!''+'b'My+family+and+I+will+never+forget+Friday,+January+20th,+2017.+Thank+you!'',+''+is+unnecessary.Hope是有帮助的。|type|unstyled|depth|inlineStyleRanges|offset|length|style|CODE|BOLD|entityRanges|data|5910220|entityMap^0|9|7|12|F|1I|26|H|1|3P|2|0^^$0|@$1|2|3|4|5|6|7|I|8|@$9|J|A|K|B|C]|$9|L|A|M|B|C]|$9|N|A|O|B|C]|$9|P|A|Q|B|D]|$9|R|A|S|B|D]]|E|@]|F|$]]|$1|G|3|-4|5|6|7|T|8|@]|E|@]|F|$]]]|H|$]]

Your sql is not right.<code>'b'My family and I will never forget Friday, January 20th, 2017. Thank you!'',</code> <code>'b'M...</code>the ' is unnecessary.and <code>...Thank you!''</code> the '' is unnecessary.Hope that helps.

blocks|key|2125226|text|给出错误是因为sql语法不正确如果您插入带有某些特殊字符数据，如“‘”，则需要在特殊字符前加上斜杠。|type|unstyled|depth|inlineStyleRanges|entityRanges|data|2125227|我和我的家人|2125228|+b‘y永远不会忘记2017年1月20日星期五。谢谢！‘|blockquote|2125229|2125230|2125231|字符串到数据库而不是b‘我给出错误，所以你需要在’like‘前添加斜杠|2125232|2125233|+b\‘我和我的家人永远不会忘记2017年1月20日星期五。谢谢！’|2125234|2125235|2125236|Mysql函数mysql_real_escape_string会自动处理这个问题，因此您只需使用Mysql函数更改字符串即可。|offset|length|style|CODE|2125237|如果您使用mysqli而不是它的mysqli_real_escape_string函数|BOLD|2125238|完整的示例代码|2125239|$link+=+mysqli_connect('localhost',+'***',+'***');

$r+=+"b'My+family+and+I+will+never+forget+Friday,+January+20th,+2017.+Thank+you!'";
//echo+$r;

$r+=+"b'My+family+and+I+will+never+forget+Friday,+January+20th,+2017.+Thank+you!'";
echo+mysqli_real_escape_string($link,$r);|code-block|syntax|javascript|2125240|对不起，我的英语不好|2125241|entityMap^0|0|0|0|0|0|0|0|0|0|0|7|O|0|G|P|0|0|0|0^^$0|@$1|2|3|4|5|6|7|19|8|@]|9|@]|A|$]]|$1|B|3|C|5|6|7|1A|8|@]|9|@]|A|$]]|$1|D|3|E|5|F|7|1B|8|@]|9|@]|A|$]]|$1|G|3|-4|5|6|7|1C|8|@]|9|@]|A|$]]|$1|H|3|-4|5|6|7|1D|8|@]|9|@]|A|$]]|$1|I|3|J|5|6|7|1E|8|@]|9|@]|A|$]]|$1|K|3|-4|5|6|7|1F|8|@]|9|@]|A|$]]|$1|L|3|M|5|F|7|1G|8|@]|9|@]|A|$]]|$1|N|3|-4|5|6|7|1H|8|@]|9|@]|A|$]]|$1|O|3|-4|5|6|7|1I|8|@]|9|@]|A|$]]|$1|P|3|Q|5|6|7|1J|8|@$R|1K|S|1L|T|U]]|9|@]|A|$]]|$1|V|3|W|5|6|7|1M|8|@$R|1N|S|1O|T|X]]|9|@]|A|$]]|$1|Y|3|Z|5|6|7|1P|8|@]|9|@]|A|$]]|$1|10|3|11|5|12|7|1Q|8|@]|9|@]|A|$13|14]]|$1|15|3|16|5|6|7|1R|8|@]|9|@]|A|$]]|$1|17|3|-4|5|6|7|1S|8|@]|9|@]|A|$]]]|18|$]]

it's give error because sql syntax not proper it you insert data with some special character like " ' " so it's need to slashes before special character for example if you add 

<blockquote>
 b'My family and I will never forget Friday, January 20th, 2017. Thank
 you!'
</blockquote>

string into database than b'My give error so you need do add slashes before ' like 

<blockquote>
 b\'My family and I will never forget Friday, January 20th, 2017. Thank
 you!\'
</blockquote>

Mysql function <code>mysql_real_escape_string</code> automatically handle this problem so you just change your string using mysql_real_escape_string function 

if you use mysqli than it's mysqli_real_escape_string function

Full Example code 

<pre><code>$link = mysqli_connect('localhost', '***', '***');

$r = "b'My family and I will never forget Friday, January 20th, 2017. Thank you!'";
//echo $r;

$r = "b'My family and I will never forget Friday, January 20th, 2017. Thank you!'";
echo mysqli_real_escape_string($link,$r);
</code></pre>

Sorry for my bad english

<pre><code>INSERT INTO fb_public_figure_posts VALUES ('153080620724_10158531267690725',
 'https://www.facebook.com/DonaldTrump/videos/10158531267690725/',
 '2017-01-23T20:36:07+0000',
 '2017-01-24T00:22:49+0000',
 'Donald J. Trump',
 153080620724,
 'b'My family and I will never forget Friday, January 20th, 2017. Thank you!'',
 'https://www.facebook.com/DonaldTrump/videos/10158531267690725/',
 123471,
 8263,
 153080620724)
</code></pre>

when running this sql sentence, it errors:

<pre><code>1064(42000), "You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 
'My family and I will never forget Friday, January 20th, 2017. Thank you!'','http' at line 1"
</code></pre>

could you please help me for that

mysql: maybe string or bytes error when insert

翻译质量差，导致语言生硬或混乱。

没有提供实际的解决方法或示例。

解答不清晰，无法理解或解决问题。

页面排版不美观，阅读体验差。

文章

问答

视频

学习中心

腾讯云实验室

直播

竞赛

腾讯云代码分析专区

腾讯iOA零信任安全管理系统专区

腾讯云架构师技术同盟交流圈

腾讯云数据库专区

腾讯云顾问专区

腾讯云原生专区

腾讯混元专区

腾讯云TCE专区

腾讯云Lighthouse专区

腾讯云HAI专区

腾讯云Edgeone专区

腾讯云存储专区

腾讯云智能专区

腾讯轻联专区 

腾讯云开发专区

TAPD专区

腾讯轻量云游戏服专区

腾讯云最具价值专家

腾讯云架构师技术同盟

腾讯云创作之星

腾讯云开发者先锋

腾讯云代码助手

云原生构建

TAPD 敏捷项目管理

Cloud Studio

SDK中心

API中心

命令行工具

涵盖代码开发、场景应用、自动测试全流程，助你从零构建专属AI助手

一站式MCP教程库，解锁AI应用新玩法

INSERT INTO fb_public_figure_posts VALUES ('153080620724_10158531267690725',    'https://www.facebook.com/DonaldTrump/videos/10158531267690725/',    '2017-01-23...

问mysql:插入时可能出现字符串或字节错误
EN

Stack Overflow用户

社区

活动

圈层

关于

腾讯云开发者

热门产品

热门推荐

更多推荐

问mysql:插入时可能出现字符串或字节错误EN