sql 字段替换/随机数

update room_articles set pic=replace(pic,'/public','') where 你的条件;
INSERT into xxx (rand_id) VALUES ((SELECT CAST(RAND()*1000 AS signed) AS rand))

Last modification：August 17th, 2020 at 09:44 am

如果觉得我的文章对你有用，请随意赞赏

友儿 • 2020 年 07 月 08 日

update room_articles set pic=replace(pic,'/public','') where 你的条件;
INSERT into xxx (rand_id) VALUES ((SELECT CAST(RAND()*1000 AS signed) AS rand))