mysql 批量替换语句 指定ID

update zw_post set log_PostTime =replace (log_PostTime, '1163033578', '1163033578') where log_ID between 1 and 100;

update 数据表 set 替换的字段 =replace (替换的字段, '要替换的关键字', '新的数据') where log_ID between 1 and 100;

posted on 2016-02-17 10:44  smesun  阅读(269)  评论(0)    收藏  举报