MySQL中的函数

1.concat

连接字符串，可以用于在现有基础上更新字段

UPDATE upfile
SET uploadpath = CONCAT(
    '/02see/课程设计',
    uploadpath
)
WHERE
    YEAR = '2019'
AND period = 7
AND uploadpath NOT LIKE '%02see%'