SQL批量语句_sql语句批量-优快云博客

本文链接：https://blog.youkuaiyun.com/maxjyp/article/details/134683698

文章概述了使用SQL语句进行数据库操作的过程，包括更新新闻内容字段（去除尾部空格），筛选并设置非图片字段的状态以及更新特定范围内的记录。

摘要生成于 C知道，由 DeepSeek-R1 满血版支持，前往体验 >


-- 清除各个字段两头的引号
-- update `jyp_idnews` set title = right(title, length(title)-1) WHERE title like '"%';
-- update `jyp_idnews` set title = LEFT(title, length(title)-1) WHERE title like '%"';
-- update `jyp_idnews` set content = right(content, length(content)-1) WHERE content like '"%';
-- update `jyp_idnews` set content = LEFT(content, length(content)-1) WHERE content like '%"';
-- update `jyp_idnews` set thumb = right(thumb, length(thumb)-1) WHERE thumb like '"%';
-- update `jyp_idnews` set thumb = LEFT(thumb, length(thumb)-1) WHERE thumb like '%"';
-- update `jyp_idnews` set keywords = right(keywords, length(keywords)-1) WHERE keywords like '"%';
-- update `jyp_idnews` set keywords = LEFT(keywords, length(keywords)-1) WHERE keywords like '%"';
-- update `jyp_idnews` set description = right(description, length(description)-1) WHERE description like '"%';
-- update `jyp_idnews` set description = LEFT(description, length(description)-1) WHERE description like '%"';


-- 更新条件中所有字段状态为1
-- update `jyp_idnews` set status=1 where id<198180;
 
-- 查询范围内所有的非图片字段数量
-- SELECT count(1) FROM `jyp_idnews`
-- WHERE thumb NOT LIKE '%.jpg'
--   AND thumb NOT LIKE '%.jpeg'
-- 	AND thumb NOT LIKE '%.png'
--   AND thumb NOT LIKE '%.gif'
--   AND id<198180;

-- 更新范围内所有的非图片状态为0
-- update `jyp_idnews` set status=0 
-- WHERE thumb NOT LIKE '%.jpg'
--   AND thumb NOT LIKE '%.jpeg'
-- 	AND thumb NOT LIKE '%.png'
--   AND thumb NOT LIKE '%.gif'
-- 	AND id<198180;