谁能帮忙修改下错误?执行以后提示影响了0行update dede_addonarticle set body=replace(body,'<script type="text/javascript"><!--
google_ad_client = "pub-8699713830098570";
google_ad_width = 468;
google_ad_height = 60;
google_ad_format = "468x60_as";
google_ad_type = "image";
//2007-09-02: FHF468x60_image
google_ad_channel = "3932908007";
//-->
</script>
<script type="text/javascript"
src="http://pagead2.googlesyndication.com/pagead/show_ads.js">
</script>','<script type="text/javascript"><!--
google_ad_client = "pub-9974701867086682";
/* 468x60, 创建于 10-8-13 */
google_ad_slot = "5640655013";
google_ad_width = 468;
google_ad_height = 60;
//-->
</script>
<script type="text/javascript"
src="http://pagead2.googlesyndication.com/pagead/show_ads.js">
</script>') where body LIKE '%1%'
google_ad_client = "pub-8699713830098570";
google_ad_width = 468;
google_ad_height = 60;
google_ad_format = "468x60_as";
google_ad_type = "image";
//2007-09-02: FHF468x60_image
google_ad_channel = "3932908007";
//-->
</script>
<script type="text/javascript"
src="http://pagead2.googlesyndication.com/pagead/show_ads.js">
</script>','<script type="text/javascript"><!--
google_ad_client = "pub-9974701867086682";
/* 468x60, 创建于 10-8-13 */
google_ad_slot = "5640655013";
google_ad_width = 468;
google_ad_height = 60;
//-->
</script>
<script type="text/javascript"
src="http://pagead2.googlesyndication.com/pagead/show_ads.js">
</script>') where body LIKE '%1%'
解决方案 »
- ERROR 1048 (23000): Column 'col' cannot be null 问题
- 求这个update语句执行顺序以及效率
- 设置列约束中有NOT NULL,为什么还是可以向里面插入空值??
- mysql default 值错误
- MySql求一语句:
- MySQL 触发器的问题:如何得到delete操作的结果集?
- 一个sql语句的简单问题,请别见笑!
- 请问怎样从我产生的临时表里再进行查询?急!谢谢!
- Mysql的count查询,如果没有结果返回NULL,怎么让他返回0
- 如何把这两张表合并?
- 在html中有的空格数据库中会怎么显示?
- 如何限制mysql账号对数据库服务器cpu以及I/0资源等的使用率,比方限制为50%!
看看是否有记录存在2:看看执行UPDATE的时候是否发生了错误?把替换的字符串用'ABC'替换试试。