mysql之统一刷表

统一刷表:

update report set pdfPath= CONCAT(pdfPath ,substring_index(fileLink, '\', -1));


update report set pdfPath = "D://report//gsyj//1_1000//"

原文地址:https://www.cnblogs.com/sqy-yyr/p/9394232.html